Date format

[Terrorke]

Hi,

Can anybody tell me how to convert this dateformat into another dateformat in MSSQL 2K?

The format of the data is : '20071015122532Z'

Thanks in advance.

Kind regards,

[criterion9]

What is the datatype of the column in question? DATE, TIMESTAMP, etc? Without knowing that a string of numbers and letters doesn't help much.

[Terrorke]

I think it is a timestamp.
But I'm not sure because I get the data from a export file of a Java environement.

[Phill Pafford]

Hmm looks like it's

YYYYMMDDHHMMSS the z could be a country code or something
20071015122532Z

You could just take the substring of 14 (20071015122532) and convert it this way, don't know if you need the Z though.

[felgall]

Z is a common abbreviation for zulu (also known as UTC or GMT)

[Terrorke]

Thanks!
I will try this and just skip the Z in it.