Hi again all,
Just here to pick some more brains.
I have some code that gets a date from a MySQL database and does some weird
and wonderful calucaltions with it.
I wish to store the end result back into the MySQL database. When I try it,
using a number of different methods, it doesn't work.
Any ideas as to the best way to store a date in a MySQL database using php?
Thanks again in advance.
Regards,
Schmalz
Just store it in unsigned int column as a php time() (unixtime) value....
You can get it from db using from_unixtime() function, or as is... You can
store it as is, or using unix_timestamp() function... Everything you
want.....
"Schmalz"
news:460a8491$0$4611$61c65585@un-2park-reader-01.sydney.pipe networks.com.au...
> Hi again all,
>
> Just here to pick some more brains.
>
> I have some code that gets a date from a MySQL database and does some
weird
> and wonderful calucaltions with it.
>
> I wish to store the end result back into the MySQL database. When I try
it,
> using a number of different methods, it doesn't work.
>
> Any ideas as to the best way to store a date in a MySQL database using
php?
>
> Thanks again in advance.
>
> Regards,
>
> Schmalz
>
>
Post removed (X-No-Archive: yes)
On Mar 28, 8:06 am, "Schmalz"
> Hi again all,
>
> Just here to pick some more brains.
>
> I have some code that gets a date from a MySQL database and does some weird
> and wonderful calucaltions with it.
>
> I wish to store the end result back into the MySQL database. When I try it,
> using a number of different methods, it doesn't work.
>
> Any ideas as to the best way to store a date in a MySQL database using php?
>
> Thanks again in advance.
>
> Regards,
>
> Schmalz
I convert my time fields to minutes from midnight (midnight being 0,
1159pm being 1439) Its not human readable but it is computer
calculable.
When I need to have user reporting or input I have a set of functions
set up to do the conversions/validation as needed.