Dear all,

Is there any one know how to use CONVERT function in TSQL to convert the datetime field into the following format.

YYYY/MM/DD HH24:MIS

Regards,

Thomas HO

select CONVERT(CHAR(24),GETDATE(),120)

Depending on how picky you are, you might prefer:-PatP

Sorry, but I get the following error message:-

Line 4:
120 is not a valid style number when converting from DATETIME to a character string.

????? what version of sql server?

i use 120 all the time, it's my favourite, it's the ISO standard

Hi Ruby,

I'm using Sybase 12.5.1.

Regards,

Thomas HO

sorry, i keep forgetting that there are actually two completely different databases, both coincidentally called sql server

you're right, sybase's does not apeear to supoprt style 120

see http://manuals.sybase.com/onlinebook...uery=convert#X

note that only two styles include the time

Ruby,

Do you mean I have no way to convert a datetime into the following format:-

YYYY/MM/DD HH24:MIS

please, the name is Rudy -- "Ruby" once is a typo, twice is an error

yes, you can get the format you want, but it may take several functions

do you have a manual?

Thanks Rudy!

I manage to do it with the following:-

SELECT Convert(CHAR(10), GetDate(), 111)+' '+Convert(CHAR(8),GetDate(),108)


Thanks a lot !!!!

Bye!!