tags:

views:

61

answers:

1
Q: 

str_to_date for ruby on rails?

so I have to insert a bunch of records from a data source that has dates in the format Sun, Sep 13 1:00 PM.

I'm just going to execute SQL that uses STR_TO_DATE

But I was wondering in case I need it in the future if you guys know of a way to do this using a ruby method...like a reverse strftime

+1  A: 

Yes, look at Datetime.strptime and the nearby Datetime.parse (similar methods for Date).

Pretty much any language that uses the C strftime will have strptime as well.

Kathy Van Stone  2009-09-11 15:40:03
hmmmmmm i thought i looked through the Date and Time ruby functions but i guess i should be more thorough and less stack overflow trigger happy. thanks anyway though!
Neil Sarkar  2009-09-11 15:57:32
It helped that I knew what to look for -- I went straight to strptime. Note that it is a class method, not an instance method.
Kathy Van Stone  2009-09-11 16:41:51

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?