Changing the Date type?

jonsof

I want to chagne the form which date is displayed. YYYY-MM-DD to
DD-MM-YYYY

Is that possible?

matto

if you want to achieve this in php:
have a look at the php date/time functions and explode() on www.php.net.

in sql:
there are date/time formatting functions, too, in the various sql dialects (which sometimes differ). but you have to use a "date" datatype field in order to work with them. if so, look up the to_char() function in your sql reference.

DoD

but instead, i decided to make my field text, with its value being the date (set by php) accoring to mk_time i think so i can manipulate it easily afterwards to my linking.

Look at php.net: http://www.php.net/manual/en/function.mktime.php

edited - pointed to gm_date and said mk_time now correceted

You might want to add the date to the database as:

$hour, $minute, $second, $month, $day, $year for the date (includes time as well)

Also, make it so if they are empty, they are 0 - as im not sure how the function handles it being empty.

The use the explode() function when back off the database to get $hour etc by spiltting it by the ", " es

Also, this means easy manipulation.

jonsof

i used the following

date("d-M-Y",mktime($date['date_posted']));

which $date_posted comes from the database DATE fields

the dates are 2 days ago but it outpouts

13 Mar 2003 , why was it shifted?

cgraz

If you're using mysql, I think the easiest way is using DATE_FORMAT()


$query = mysql_query("SELECT DATE_FORMAT(date_d, '%d %m %Y') AS DATE WHERE id=7");

Assuming date_d is your field name, that will display

DD MM YY

To get the dashes in there, I'm pretty sure you can just add the dashes right in the query.

$query = mysql_query("SELECT DATE_FORMAT(date_d, '%d-%m-%Y') AS DATE WHERE id=7");

Cgraz

jonsof

I did it! thank you all!!