asp.net - datagrid and date?

[Morten]

Hi.

I have a problem getting date coorect in my datagrid.
Date in the database is integer like this 20010614
I create a View and I have tried cast but I can not get passed dd.mm.yyyy
hh:mm:ss
I want the date in the grid to come out as dd.mm.yyyy

Any ideas?

Thanks

Morten

 

[Deepankar]

Hi,
I would prefer to do the conversion in the backend
Something like this
declare @m int
set @m = 20010605

select cast(substring(cast(@m as varchar(10)),1,4) + '.' +
substring(cast(@m as varchar(10)),4,2)
+ '.' + substring(cast(@m as varchar(10)),8,2) as datetime)

Thanx
Deep

 

[Morten]

Thanks Deepankar

Hi,
I would prefer to do the conversion in the backend
Something like this
declare @m int
set @m = 20010605

select cast(substring(cast(@m as varchar(10)),1,4) + '.' +
substring(cast(@m as varchar(10)),4,2)
+ '.' + substring(cast(@m as varchar(10)),8,2) as datetime)

Thanx
Deep