[tallpaul858]

ive got a date stored in my mysql database as 00/00/0000 (dd/mm/yyyy)

i dont want to store it as 00/jan/0000 for many reasons.

is there an easy way of taking the month as 01 and converting it into JAN or 03 to MAR without writing a whole load of if / case statements?

ie. is there a way of doing it with date() or timestamp() ? i only want to display it as MAR,JUN etc... not convert it in the db.

thanks,

paul

[moronovich]

rtfm first:

php functions: date, mktime, strtotime

pointer:
common date format: (long) timestamp -> saved in db
displayed format: (string) date -> converted from the timestamp saved in db

[JBChris]

Make a timestamp with your sql date, then insert it where you would put a timestamp in date().

PHP Code:

<?php

print date('M'[, timestamp]);

?>

[tallpaul858]

thanks guys, thats helped loads,

got it working now,

regards, paul