Re: [PHP] Date/time format?



Jason Pruim wrote:
Hi Everyone,

First off, I'm using PHP 5.2.0 and apache 1.3.33

I am trying to figure out what format a string is in in a database. It's a timecard system that I have found on-line and I am attempting to figure out how to write a script that would give me everyones timecard for the month on one screen I can print out for accounting to use. Below is an example of one of the lines in the database, What I'm really interested in is how it represents the "day".

user day job_name minutes sequence

root 1171774800 Production & technology Manager 990 3
Could it be Feb 18, 2007 ??

If so, then that is just the unix timestamp.
echo date('r', 1171774800);

more data functions at: http://www.php.net/date
-B

I have not been able to find ANY info about that format, other then other people using it in blogs. I think I can figure out the rest as I go if I know how to decode the day. Any help or pointers to the "M" would be GREATLY appreciated! :)



--
Jason Pruim
japruim@xxxxxxxxxx
Production & Technology Manager
MQC Specialist (2005 certified)
3251 132nd Ave
Holland MI 49424
616.399.2355
www.raoset.com


“Give me your tired, your poor,
Your huddled masses yearning to breathe free,
The wretched refuse of your teeming shore.
Send these, the homeless tempest-tost to me,
I lift my lamp beside the golden door!”

From “The New Colossus,” by Emma Lazarus



.



Relevant Pages

  • Re: [PHP] Date/time format?
    ... Jason Pruim wrote: ... I am trying to figure out what format a string is in in a database. ... Below is an example of one of the lines in the database, What I'm really interested in is how it represents the "day". ... I have not been able to find ANY info about that format, other then other people using it in blogs. ...
    (php.general)
  • Re: [PHP] Date/time format?
    ... I am trying to figure out what format a string is in in a database. ... It's a timecard system that I have found on-line and I am attempting ...
    (php.general)
  • Re: [PHP] Functions are driving me crazy....
    ... On Fri, January 25, 2008 1:59 pm, Jason Pruim wrote: ... I am attempting to write an authentication function which would query ... a database, check the username/password and return true if it matches. ... My error log shows this: ...
    (php.general)
  • Re: Question before I end up writing alot of extra code...
    ... Jason Pruim wrote: ... Some of it text boxes, some check boxes, some radio buttons... ... The problem I'm running into though, is when a value has not changed it doesn't get $_POSTed back and my update script erases the info in the database... ...
    (php.general)
  • Re: [PHP] Include files....
    ... On Fri, May 18, 2007 3:05 pm, Jason Pruim wrote: ... <?PHP ... echo 'Connected successfully '; ... Yes I changed the values of username, password, and database. ...
    (php.general)