Sorry to bother you so early in the morning, but i need some help and advice. This is my table SELECT TOP 5 [FDMSAccountNo] ,[Open_Date] FROM [FDMS].[dbo].[Dim_Outlet]
Which produces the following results FDMSAccountNo Open_Date 878000000884 20030521 878000001882 20090709 878000002880 20090709 878000003888 20090709 878000004886 20090709 I want to change the open date into the following format “2003-05-21T12:00:00Z”
this should be done at the front end application layer as its a presentation issue. Handling this in sql end will require casting to varchar which is bit of an overkill and will make further date manipulation with these values difficult
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Date function Help
Posted - 03/13/2013 : 05:11:02
