RE: Inserting Date Field

[jbonnett]

Here is a fragment of VB where I insert a date/time into MySQL

    CurDate = "'" & Format(Now(), "yyyy-mm-dd hh:nn:ss") & "'"
    SQL = "UPDATE " & mMilledObject & "s SET ArriveNPLDate = " & CurDate &
"
WHERE ID = "

I append a value for the ID further down in my code to complete the SQL
statement.

John Bonnett

-----Original Message-----
From: Ed Kraft [mailto:ekraft@stripped]
Sent: Friday, 4 July 2003 2:22 AM
To: 'myodbc'
Subject: Inserting Date Field


Hey All,

How do I insert a date field into my mySQL db?  I had it working with
Access (using the date()) function.  Now after looking here:

http://www.mysql.com/doc/en/Date_and_time_functions.html

I see that it has to be done differently.  I've tried using the CURDATE
function, but that doesn't do anything within my ASP pages.

Thanks,

Ed