Have you considered using the string to time function?
Sent via BlackBerry from T-Mobile
From: "Bryan Cantwell" <bcantwell@stripped>
Date: Mon, 21 May 2007 12:08:11
To:"MySQL General" <mysql@stripped>
Subject: string to timestamp conversion
I have a table with a varchar column that contains a timestamp like
this: 'Thu May 17 09:15:47 2007'
I need to grab this and include it in an insert sql that puts that value
in a table as a timestamp...
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1