Technology, Support, and News Forum

[Leychay Profile]

hye~

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

[NT50 Profile]

Be patient and somebody should be by soon to help you with this.

[Leychay Profile]

ok NT50~

thanks for the encouragement~

appreciate dat

[NoReflex Profile YIM]

I think you might find some help here :
http://www.w3schools.com/php/php_ref_date.asp
Good luck!

Best wishes,
Ionut

[Leychay Profile]

thanks NoReflex~

i'll try and check it out!~~


i've checked the page u gave to me, but i still cant find the right function to use it...

i think myb the function need to be execute using mysql query or something like dat~~

mybe someone can help me more?

i really appreciate ur help!~

[NoReflex Profile YIM]

If you want to use sql to do this you could use the time() function for extracting the time part:

Code: Select all

mysql> SELECT TIME('2003-12-31 01:02:03');
        -> '01:02:03'
mysql> SELECT TIME('2003-12-31 01:02:03.000123');
        -> '01:02:03.000123'

and date() function to extract the date :

Code: Select all

mysql> SELECT DATE('2003-12-31 01:02:03');
        -> '2003-12-31'

You can find the complete reference for date and time sql functions here :
http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

I hope this helps you. Good luck!

Best wishes,
John

[Leychay Profile]

a million thanks to u NoReflex~~

i've got it now~~

now i just want to try to explore more about its function~~

thanks again~!