Need help: Using a Mysql Timestamp field in PHP

Home • Watched Topics • Register • Search• Directory
FAQ • Memberlist • Usergroups • Log in• Stores • Items • Bank

THE PHP FORUM.NET IS HIRING MODERATORS.
PLEASE SEND A PRIVATE MESSAGE TO PRATAMISHUS IF YOU WANT TO EARN SOME EXTRA CASH (Registered users only).

The time now is Wed Aug 27, 2008 7:25 pm

View previous topic | View next topic

Page 1 of 1

Need help: Using a Mysql Timestamp field in PHP

Message

rfeio
nOObee

Joined: 25 Oct 2007
Posts: 1

33 Cash

Need help: Using a Mysql Timestamp field in PHP

Hi!

I have a table where one of the fields is a timestamp. I would like to use this field in PHP, and separate the Year, Month and Day into separate variables. For some reason I'm always getting 1970, 01, 01.

Can someone help?

Thanks!

Thu Oct 25, 2007 2:49 pm

142TeeTH
Trainee Developer

Joined: 26 Nov 2007
Posts: 8

240 Cash

Hm, sounds odd. Would you mind posting that snippet of the code?

You could also look over your code. If you defined that timestamp as a variable. You could do:

Code:

$formattedtime = date('Y m d', $timestamp);

Just make sure the spelling's right, etc.

Mon Nov 26, 2007 7:52 pm

The time now is Wed Aug 27, 2008 7:25 pm | All times are GMT - 6 Hours

Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

FireFox!	The PHP Forum	Loans and Credit
Panama	Web Design for Hire	Free Insurance Quotes!
Web Hosting	Advertise Here $10 a Month	Designer Children
Never Pay Taxes Again	HGH	Domain name registration
Web Hosting and Dedicated Servers	Insurance	Affordable web-hosting

Web Design by PlatinumShore.com & Web Hosting by TradeWebHosting.com