Formatting variables.

[sjchandru]

Hi everybody,

I have a table in oracle database with a date column. I tried to get a record from the above table and display it in my web page. The database column contains date and time, but in the web page, only date was displayed.

I retrieve the record and store this date column in a variable. How should I format this string variable (say $erdate). I simply set this variable for the value property of a text box.

Is there any format option to change the variable to the following format?

"15/03/2003 10:30"

Thanks and regards,
Chandramohan J.

[ir4z0r]

hi,

i don't know your db-date-format, but maybe strtotime() can help.
this function analyses a literal date'n'time and returns a timestamp.
with gmdate() you are then able to format your time properly