date postgres and php
Posted: Tue May 06, 2003 4:24 pm
any suggestions on this would be appreciated:
when selecting a date from a table on a postgres DB the date is returned in this format:
2003-05-06
i would like to change the date when outputted with PHP to:
05/06/2003 (or any other format that i would like)
can you reformat the date with postgres or am i going to have to explode it with php?
select date_format(mm/dd/yyyy,inevents_date) from events
or
explode('-'.$data[inevents_date])
any ideas?????
(examples would be great!!)
when selecting a date from a table on a postgres DB the date is returned in this format:
2003-05-06
i would like to change the date when outputted with PHP to:
05/06/2003 (or any other format that i would like)
can you reformat the date with postgres or am i going to have to explode it with php?
select date_format(mm/dd/yyyy,inevents_date) from events
or
explode('-'.$data[inevents_date])
any ideas?????
(examples would be great!!)