Parsing string to datetime month & day reversed

Hello,

I have a parse that reads in a file and populates my database. The
problem is that when I use Time.parse it interprets the second digit as
the month rather than the day.

For example:
Input: 12-04-2007 21:15:56
Shows as Apr 12, 2007

Controller Line: wanted.earlist_pre_order = Time.parse(items[12])

Any help would be greatly appreciated.

Barb

Barb W. wrote:

Hello,

I have a parse that reads in a file and populates my database. The
problem is that when I use Time.parse it interprets the second digit as
the month rather than the day.

For example:
Input: 12-04-2007 21:15:56
Shows as Apr 12, 2007

Controller Line: wanted.earlist_pre_order = Time.parse(items[12])

Any help would be greatly appreciated.

Barb

Well that’s not an error. It depends on where you live. I think you can
try somewhere the strftime method

On Dec 28, 2007 10:34 PM, Barb W. [email protected]
wrote:

Controller Line: wanted.earlist_pre_order = Time.parse(items[12])

Any help would be greatly appreciated.

Date/Time.parse uses a variety of heuristics in an attempt to deal
with the various ways we present dates around the world.

I think that using “-” for the separator triggers it to interpret the
date in EU format dd-mm-yyyy and a ‘/’ causes it to use the US
interpretation mm/dd/yyyy


Rick DeNatale

My blog on Ruby
http://talklikeaduck.denhaven2.com/

On 12/28/07, Barb W. [email protected] wrote:

Any help would be greatly appreciated.
You can use strptime to parse dates/times with unusual formats:

http://www.ruby-doc.org/core/classes/DateTime.html#M002824


Greg D.
http://destiney.com/

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs