List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:May 22 2007 7:53am
Subject:Re: string to timestamp conversion
View as plain text  
Like:

  str_to_date('Thu May 17 09:15:47 2007','%a %b %e %T %Y')

On Mon, May 21, 2007 21:10, seungp@stripped wrote:
> Have you considered using the string to time function?
>
>
> Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> 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
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>


-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

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