I have noticed a thread on this forum concerning the problem with the timestamp field in MySql.

I am having the same problem, and being a newbie i dont understand how to achieve the solution.

Could you possibly help me ????

Everything is working accept the timestamp (which is working in its predefined format
YYYYMMDDHHMMSS or something like that)

and i want it to display for eg 21st of december 2001 4:58pm or something similar.

PLeaaaaaaasssssssssseeeeeeeeee Help <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>

Thanks in Advance Mat

Not really sure I understand, but if you wish to store the date an entry was made in to the database, then I always find it easier to use PHP's date() function and store the output from that in a field.
www.php.net/date

George

Everybody has got to be somewhere

Hi George.

Ok i dont know how too pass that value of date() to my database using a form in ultradev, could u possibly enlighten me???

Thanks in Advance Matty S

Hi madmatuk,

To display a timestamp value from mysql, you have either two choices :

1. You ask mysql to format the timestamp in the date string you wish. To do that, use the mysql date and time function : .www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions

2. You may use the formatting options of UD when inserting the Timestamp value into your page. To do that, once you have inserted your timestamp onto the page, select it in the Data Bindings palette. Then click on the right, the arrow. This will trigger a menu that will let you choose which format you want to apply.

Hope this help.

Bruno

--- Better to die trying, than never try at all ---