List:General Discussion« Previous MessageNext Message »
From:Chris Boget Date:May 21 2007 8:50pm
Subject:RE: string to timestamp conversion
View as plain text  
Take a look at the following:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func
tion_unix-timestamp

That looks like exactly what you need...

thnx,
Chris 

-----Original Message-----
From: Bryan Cantwell [mailto:bcantwell@stripped] 
Sent: Monday, May 21, 2007 4:45 PM
To: MySQL General
Subject: RE: string to timestamp conversion

I see no string to date function that does this conversion...

 
-----Original Message-----
From: Bryan Cantwell
Sent: Monday, May 21, 2007 2:08 PM
To: MySQL General
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

Thread
load control character....helpAnanda Kumar21 May
  • string to timestamp conversionBryan Cantwell21 May
    • Re: string to timestamp conversionseungp21 May
  • RE: string to timestamp conversionBryan Cantwell21 May
  • Re: string to timestamp conversionMogens Melander22 May
RE: string to timestamp conversionChris Boget21 May