date/time question..

HakonHoy

I have a field called: news_date in a my sql db... it is a "datetime" thing, and it stores the date in this format 0000-00-00 00:00:00 .. how can I display the date in other formats? eg. the day and the month ?

what code do I use to e.g. display it in Europeen time (CET), and in this way, Thursday 23 March 2006 ?

Can anyone please help me, I would be very happy.

Blulagoon

Dates and times are a right pain in SQL (IMHO). I tend to use the php function mktime() to create the unix time stamp (seconds elapsed since Jan 1 1970), store it as an interger in the db and then use strftime() or date() to format the date as I want it.

A very simple examle would be:
$today=mktime();
print strftime('%c',$today);

If you want to use MySQL date and time functions then you need to use date_format() with the following syntax, where your date information is in a column called date

select date, DATE_FORMAT(date, '%M %d %Y) as format_date from mytable

This will give you the date in the format March 23 2006, other formats are available, take a look at DATE_FORMAT in the MySQL manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

Blu.

If you want to

obsidian

HakonHoy wrote:
...it stores the date in this format 0000-00-00 00:00:00 .. how can I display the date in other formats? eg. the day and the month ?

what code do I use to e.g. display it in Europeen time (CET), and in this way, Thursday 23 March 2006 ?

easiest solution since you're already pulling it in datetime format:

<?php
$time = "2006-03-01 12:00:00";
$ts = strtotime($time);
echo date('D j F Y', $ts);
?>

good luck!

rbblue8

Helped me with my problem.

Thanks!