PHP Convert string from dd/mm/yyyy to YYYY-MM-DD HH:MM:SS string for use with ms sql server?

Question

I am hosting a php application on Windows server 2008 and using SQL Server 2008. I am having issues with inserting dd/mm/yyyy date strings in to the database.

How can I manually convert my dd/mm/yyyy string into the MS SQL Server date format YYYY-MM-DD HH:MM:SS within PHP code?

Shakti Singh · Accepted Answer · 2012-01-11 07:42:14Z

3

You can use the date and strtotime functions

$date=date('Y-m-d h:i:s', strtotime($date_in_ddmmyyyy));

answered Jan 11, 2012 at 7:42

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

YuS · Accepted Answer · 2012-01-11 07:43:41Z

2

$date = strtotime('11/01/2012');

$new_date = date('Y-m-d H:i:s', $date);

answered Jan 11, 2012 at 7:43

YuS

2,0531 gold badge15 silver badges24 bronze badges

Comments

Waqar Alamgir · Accepted Answer · 2012-01-11 08:26:18Z

0

// e.g. '12/12/2040' will not work

$date = strtotime('12/12/2035');

if($date !== false)
{
    $date = date('Y-m-d h:i:s' , $date);
}
else
{
    $date = 'can\'t convert';
}
echo $date;

answered Jan 11, 2012 at 8:26

Waqar Alamgir

9,9884 gold badges33 silver badges37 bronze badges

Collectives™ on Stack Overflow

PHP Convert string from dd/mm/yyyy to YYYY-MM-DD HH:MM:SS string for use with ms sql server?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related