[RESOLVED] Translating Someone else's Dates

[netfrugal]

I like using dates like this: YYYY-MM-DD (which is typical for db development)

But I occasionally get dates passed on to me, either in csv, or some other method - which don't follow that typical db pattern.

The latest one I got is this: 13-nov-2008

Looking into the date() function I can see that is: date('d-M-Y');

I want to import their dates into my database. Is there a function that can translate different date formats into a format I need?

[NogDog]

[man]strtotime/man is your friend (as long as the date string is something it recognizes):

<?php
$date = '13-nov-2008';
$ymd = date('Y-m-d', strtotime($date));
echo $ymd;

[netfrugal]

You rock!

Get some sleep! 🙂

[NogDog]

netfrugal;10902034 wrote:

You rock!

Get some sleep! 🙂

I did. I just now finished breakfast. 😉