how to write the data of datetime type in database to the html document?

[liuyue]

i have another question. how can i write the data of datetime type in sql server to the html document. the data of datetime from database is VARIANT (VT_DATE), but there is not datetime type in html. could you tell me how to do? thanks

[Marc Soleda]

Retrieve the string from the variant and then write it like you desire in the html. ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

[liuyue]

are there the functions that convert the datetime format to string format?

[Marc Soleda]

Try to retrieve the VT_BSTR part of the VARIANT instead of the VT_DATE. Marc Soleda. ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.