Jump to content


Photo

date/time displaying..


  • Please log in to reply
1 reply to this topic

#1 HakonHoy

HakonHoy
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 12 March 2006 - 07:28 PM

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 ?
[!--sizeo:1--][span style="font-size:8pt;line-height:100%"][!--/sizeo--][!--fonto:Verdana--][span style="font-family:Verdana"][!--/fonto--]My network of web sites:
[a href="http://www.xbox-talk.com/" target="_blank"]xBox-Talk.com[/a] - [a href="http://www.balando.com/" target="_blank"]Balando.com[/a]
[a href="http://www.humorhour.com/" target="_blank"]HumorHour.com[/a] - [a href="http://www.ordigno.com" target="_blank"]Ordigno.com[/a] - [a href="http://www.playword.info" target="_blank"]Playword.info[/a]
[a href="http://www.casinopromos.info/" target="_blank"]CasinoPromos.info[/a] - [a href="http://www.betbonus.info/" target="_blank"]BetBonus.info[/a] - [a href="http://www.newroomtalk.com/" target="_blank"]NewRoomTalk.com[/a][!--fontc--][/span][!--/fontc--][!--sizec--][/span][!--/sizec--]

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 12 March 2006 - 08:22 PM

You need to look (carefully) at table 1 in the [a href=\"http://ca.php.net/manual/en/function.date.php\" target=\"_blank\"]date() function in the manual[/a]. Look over the user notes as well, and you'll find an example of what you're trying to do.
Legend has it that reading the manual never killed anyone.
My site




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users