angst
04-28-2004, 03:14 PM
Hello,
I'm just trying to insert a datetime value into mysql datetime feild,
but everytime run the script, and then look in the data base all i see is 0000-00-00 00:00:00
whats going on here?
my code
sql= "INSERT INTO ForumPosts (PostDate) VALUES ('" & NOW() & "')"
set rs= MyConn.execute(sql)
set sql= nothing
I'm just trying to insert a datetime value into mysql datetime feild,
but everytime run the script, and then look in the data base all i see is 0000-00-00 00:00:00
whats going on here?
my code
sql= "INSERT INTO ForumPosts (PostDate) VALUES ('" & NOW() & "')"
set rs= MyConn.execute(sql)
set sql= nothing