Printable View
OK, now if i create a record in my table, (mysql) i have a timestamp field, so it fills in like:
20021201214855
Translated To:
Date: 01 December 2002
Time: 21:48:55
Now, i know its in the form:
YearMonthDayHourMinuteSecond
But, is there a way (Already made) That will make it into an easy to read manner?
And if i can split it into the actual Date & Time seperate, Cool
Use the Date() function:
Code:Date('d m Y', $time_stamp_here)
Doesn't seam to do the trick?
20021201214855 -> 19 01 2038
using:
& Using:PHP Code:Date('d m Y',$lutimestamp)
PHP Code:Date('d m Y',"20021201214855")
Tnx,
Don't Spose theres a Left$() + Right$() Function in php?
It should work fine...
No, there is no Left() or Right(). Use the substr() function.
Are you misunderstanding the format of a unix timestamp? I don't know much about them, so I'm not sure, but when I run this code:
I get '1038760871' for the timestamp.Code:echo mktime(11, 41, 11, 12, 1, 2002);
Oh, it isn't on a *nix system,
It's on a Win2k Pro SP3 Server.
I Will Test The date() Thing On My Hosted Server L8r.
Im not certain, This is the TimeStamp field for a MySQL Database Feild,Quote:
Are you misunderstanding the format of a unix timestamp?
I am importing a CSV File regularly, & want to b able to get the time the file was imported, without altering the file to add the time to 200 + records manually.
Say What? (Little Lost @ This?)PHP Code:echo mktime(11, 41, 11, 12, 1, 2002);
OK, will look @ The manual 4 this when i get bk from college, split the date & Time from the stamp manually if all else fails.Quote:
Use the substr() function
You don't have to be on a unix system to use a unix timestamp.
And as far as I know, they are the only kind of timestamps used by PHP and MySQL. Anyone who knows better, feel free to ring in now.
The mktime() function returns a unix timestamp based on the date you give it:
Code:echo mktime(HOUR, MINUTE, SECOND, MONTH, DAY, YEAR);
And you are right about the format of the timestamp, according to http://www.mysql.com/doc/en/DATETIME.html
I'm not sure why that function doesn't create it in that format. I suppose UNIX Timestamps are different than MySQL Timestamps afterall?
OK, got the substr function down too now (Bonus or what :D)
So i got the date & Time Like:
and seams to work kool,PHP Code:<?php
// Date - Day / Month / Year
echo substr($lutimestamp, 6,2)."/".substr($lutimestamp, 4,2)."/".substr($lutimestamp, 0,4);
?>
<?php
// Time - Hour:Minute
echo substr($lutimestamp, 8,2).":".substr($lutimestamp, 10,2);
?>
Little extra note with this,Quote:
Originally posted by The Hobo
You don't have to be on a unix system to use a unix timestamp.
And as far as I know, they are the only kind of timestamps used by PHP and MySQL. Anyone who knows better, feel free to ring in now.
The mktime() function returns a unix timestamp based on the date you give it:
Code:echo mktime(HOUR, MINUTE, SECOND, MONTH, DAY, YEAR);
So, if i decided to [not sure yet but probally will] make a forum, to go wiv the portal / site im buildin now,
When i add the date the post's are made the the database,
I add it like:
and then i can get it back to normal, With the users setting of the date / time by the:PHP Code:mktime(date("h"), date("i")...
Correct?PHP Code:date($user_format, $post_time);
: BTW, when u fink that vbsboard will have a public release,
: Cuz their comin on well,
Actually (don't know why I didn't use this before), do this:Quote:
Originally posted by wpearsall
When i add the date the post's are made the the database,
I add it like:
PHP Code:mktime(date("h"), date("i")...
Should give you the correct timestamp.Code:strtotime("now");