|
Posted by Chris Hope on 06/16/05 13:34
Angelos wrote:
> What do you think is the best way to store Dates into a database ?
> If you want to keep logs or buckups....
>
> I am using date('dmYHis')
> but I doesn't work really well ...
> Is it better to use date(U) ?
> Any suggestions ?
Use the date or datetime field type - the exact name of the type depends
on your DBMS.
> And if you can let me know how you can Display that date back in the
> Screen !
Depending which DBMS you are using there may be a function for
formatting the date; in MySQL for example you would use the
date_format() function.
Otherwise you can use the PHP function strtotime() to change it to a
timestamp and then date() to format it as you wish. The downside with
this is you are limited to the range of a unix timestamp which is from
1970 to 2038.
--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
Navigation:
[Reply to this message]
|