How to Write this Query

[varshavmane]

Hi All, I need to write a query in which date time field is there.I want to display only date either in dd/mm/yyyy or mm/dd/yyyy. I am not getting year in yyyy I am doing this: SELECT Convert(nvarchar,ReceivedDate, 6) AS ReceivedDateFromClient FROM Table Its results in 01 Jan 00. But I want 01 Jan 2000. Can any one help me please... Thanks in advance...

[Sun Rays]

Learning ASP.NET 2.0 wrote:

I am doing this: SELECT Convert(nvarchar,ReceivedDate, 6) AS ReceivedDateFromClient FROM Table

u have to write this SELECT Convert(nvarchar,ReceivedDate, 101) AS ReceivedDateFromClient FROM Table

Thanks, Sun Rays

[RaghuSanta]

FYI, SELECT Convert(nvarchar(11),ReceivedDate, 113) AS ReceivedDateFromClient FROM Table Regards, Raghu.

[varshavmane]

Thank you Raghu, its working.Thanks

[varshavmane]

Thank you, its working.Thanks

[Shahzad Aslam]

try this select left(ReceivedDate,11) AS ReceivedDateFromClient FROM Table Shahzad Aslam Sofware Engineer