SQL data type conversion

[li0000]

Hi,

I need to convert the a string into a TimeStamp data type. How can I do it?

Like:

String = "2005-09-02 00:00:00"

into

TimeStamp

Thanks

[erickwidya]

timestamp data type is represent in datetime type?

is this?
SELECT CONVERT( datetime, '2005-09-02 00:00:00')

[li0000]

Thank you very much for reply. I did not your code run.

Bye