Date Extraction

[bubblegum.anarchy]

Hi Everyone!

 

Here is what I am trying to do (using mysql only):

 

Convert the following strings:

 

Second Monday March

Second Monday June

First Tuesday November

Last Thursday August

 

to their respective mysql dates.

 

SET @date_string := 'Second Monday March';
SELECT MYSQLCODEGENUIS(@date_string);

[artacus]

I don't think you'll be able to do that cleanly in mysql. You should have pretty good luck with php's strtotime()

[bubblegum.anarchy]

The strtotime function was what the database values were designed for but I am now required to have the conversion performed directly in the sql query - I will have to try and find the code for the PHP strtotime function if an answer is not posted.

 

[artacus]

Well what you'd typically do is have php convert it into an actual time then store it as a data or datetime in mysql. If you really really have to store the strings, use two fields, one for the date and the other for the string.

[fenway]

Provided that you can store this string somewhere, you could split it into three parts, and then figure out how to piece it back together in the DB.q