Converting a date to mysql format

04-07-2009

Is there an easy way to convert '13-Mar-2009 20:55 PDT' into something
that ruby understands, so that I can output it in a format that mysql
understands?

04-07-2009

Crustov wrote:
> Is there an easy way to convert '13-Mar-2009 20:55 PDT' into something
> that ruby understands, so that I can output it in a format that mysql
> understands?

require 'time'
t = Time.parse '13-Mar-2009 20:55 PDT'
t.strftime("%Y-%m-%d") # => "2009-03-13"

--
vjoel : Joel VanderWerf : path berkeley edu : 510 665 3407

04-07-2009

On Apr 7, 12:26*pm, Joel VanderWerf <vj...@path.berkeley.edu> wrote:
> Crustov wrote:
> > Is there an easy way to convert '13-Mar-2009 20:55 PDT' into something
> > that ruby understands, so that I can output it in a format that mysql
> > understands?
>
> require 'time'
> t = Time.parse '13-Mar-2009 20:55 PDT'
> t.strftime("%Y-%m-%d") *# => "2009-03-13"
>
> --
> * * * *vjoel : Joel VanderWerf : path berkeley edu : 510 665 3407

Awesome. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
howto Date Time string from MYSQL to German Format	sanitarysystems@googlemail.com	Perl Misc	1	10-21-2007 12:54 PM
how can i use regular expressions to ensure a mysql format date entry in a text field?	libsfan01	Javascript	8	10-12-2006 01:56 PM
displaying the date in mysql format for insertion into db	libsfan01	Javascript	1	06-13-2006 09:03 PM
Date, date date date....	Peter Grison	Java	10	05-30-2004 01:20 PM
Date Format - best way of converting a string into a date format	Brian Candy	ASP .Net	2	02-18-2004 02:13 PM