forgive me for asking this question......

[threeo]

i have forgotten how to do this and i've been scouring the internet and can't believe i can't find the correct syntax....

all i want to do is save the value for Now() to my database.

the original value is like: 8/23/2005 9:26:45:18 PM

this is how the dates appear in the table i'm trying to save to:
2/20/2004 1:25:25 PM
and they are in datetime format

i've tried all kinds of configurations like:

CONVERT(datetime, '2005-08-23-092645', 101)

etc but always get
"error converting datetime from character string" errors

 

[Spent]

Have you tried DateToStr and StrToDate functions ?

 

[Spent]

Ops My mistake I though I am in the Delphi forum. In ASP.NET should be DateTime.Parse() and .ToString().

 

[threeo]

hey thanks...

i am building a query string which will be sent to sql server so....

i am trying to figure out how to do this in sql server rather than in .net

 

[vbkris]

why not use GetDate() function of SQL server???

Known is handfull, Unknown is worldfull

 

[threeo]

i found the answer.....

it was:

CONVERT(datetime,'2005-08-28 09:23:16.32',101)


thanks