in reply to How do you format dates for entry into MySql?

As George_Sherston says, it's usually more convenient and efficient to store the dates as an integer, if you plan to process it in your perl code later.

As seen in this node I actually could cut down the process time by a third when I switched from using the Postgres' timestamp type to an integer

As for the conversion, I think you get the idea from maverick's post :-)

  • Comment on Re: How do you format dates for entry into MySql?