You could use the built in MySQL function FROM_UNIXTIME() in your INSERT statement to convert from a unix timestamp to the datetime format.
-----Original Message----- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:57 PM To: [EMAIL PROTECTED] Subject: (RADIATOR) AcctColumnDef for MySQL datetime type Hello, What would be the proper way to insert the Timestamp from accounting into a MySQL datetime field? Basically it requires format of '0000-00-00 00:00:00' but I cannot seem to figure out how to do this with the date formatting. There is no format specifier for month with preceeding 0. Viraj. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
