|
-
October 1st, 2008, 11:20 AM
#1
TIMESAMP into mysql
Hi, i have TIMESTAMP column and i must convert his value in to date in mysql
-
October 1st, 2008, 12:09 PM
#2
Re: TIMESAMP into mysql
A timestamp column is already a date format. What exactly are you trying to do?
If the post was helpful...Rate it! Remember to use [code] or [php] tags.
-
October 1st, 2008, 02:34 PM
#3
Re: TIMESAMP into mysql
how i can extract the month and year
Last edited by ledaker; October 1st, 2008 at 02:39 PM.
-
October 1st, 2008, 02:56 PM
#4
Re: TIMESAMP into mysql
Since you haven't stated in what language you are attempting this, I will assume PHP.
PHP Code:
$row = mysql_fetch_object($sql);
$monthyear = date('F Y', strtotime($row->timestamp))
If the post was helpful...Rate it! Remember to use [code] or [php] tags.
-
October 1st, 2008, 04:21 PM
#5
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
