Change date format in result

[andem038]

Hello fixers

 

I have a problem when "select" a datetime from my db: Its in wrong format.

Now its Mar 23 2009 3:12PM, and I want in this format: yyyy-mm-dd hh:ii:ss

 

I tried to do this in php:

$date = date("Y-m-d H:i:s", strtotime( $date ) );

but then it will ignore seconds and always set seconds to "00". I need the seconds too...

 

How do I fix this?

[GeoffOs]

try wrapping your date field with the following:

select convert(varchar(50), getdate() , 20)

 

For me this produces:

2009-04-22 12:24:23

 

 

[andem038]

try wrapping your date field with the following:

select convert(varchar(50), getdate() , 20)

 

For me this produces:

2009-04-22 12:24:23

 

Hi

 

Ok, how does this work?

 

Say I have SELECT text_date_updated, text_date_created FROM table..

I want them both in the correct format.

[GeoffOs]

Try:

SELECT convert(varchar(20), text_date_updated, 20), convert(varchar(20), text_date_created, 20) FROM table