Have you considered using the string to time function?
Sent via BlackBerry from T-Mobile -----Original Message----- From: "Bryan Cantwell" <[EMAIL PROTECTED]> Date: Mon, 21 May 2007 12:08:11 To:"MySQL General" <mysql@lists.mysql.com> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]