(RADIATOR) AcctColumnDef for MySQL datetime type

[Frank Danielson]

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:valankar at ifxcorp.com]
Sent: Monday, June 03, 2002 1:57 PM
To: radiator at open.com.au
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.