i'm a noob in using mysql and php..i'm doing some simple system which required me to record the time and date using timestamp function.
the problem is, i want to extract the date and time recorded into two section (different column for each date and time)..
to make it simpler, as we all know, timestamp recorded data such as--> (0000-00-00 00:00:00) right?
sample data: (1990-02-25 05:12:36)
which this data in column log_info in user table.
what i want to do is, i want to extract from that data and convert it into two column which is date and time column from the column log_info.
does anyone know how to solve this?
i really need your help right now~
thanks for concerning