Hello,

I am having problem with DateTime field in Sql Server db.

FieldName: LastActionBy
FieldType: DateTime

I want to Update Current Date and Time and using following query.

"Update LOGS SET LastActionBy = '"& NOW() &"' WHERE ID = 5"

The error I get is
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"

The above mentioned query was working fine. But now it is not.



I tried following queries as well, but getting same result.
"Update LOGS SET LastActionBy = "& NOW() &" WHERE ID = 5"
"Update LOGS SET LastActionBy = #"& NOW() &"# WHERE ID = 5"


Please help!!


Regards
Zeeshan Ahmed

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

If you are using SQL server, then use the following query:

"Update LOGS SET LastActionBy = getDate() WHERE ID = 5"



Om Prakash

Alternatively, debug your SQL statement like this:

Response.Write("Sql is " & "Update LOGS SET LastActionBy = '"& NOW() &"' WHERE ID = 5")

Do you see anything odd? Is there a difference between regional settings of your web server and your database server?

I do agree with om_prakash that GetDate() is better as it gives you the date and time right where you want it: in the database...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Nowhere Fast by Incubus (Track 2 from the album: Make Yourself) What's This?