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

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



you stated in a different email that there are 6 possible values/settings for the sequence col.

what are they, and what do they mean?

One person asked about missed punches. What happens if someone forgets to clock out? Is an entry made for the person for the appropriate day/minutes/sequence ???

I can see a way to do what you are asking, but I need these questions answered first.

--
Enjoy,

Jim Lucas

Different eyes see different things. Different hearts beat on different strings. But there are times for you and me when all such things agree.

- Rush
.

Relevant Pages

  • Re: year to date conversion
    ... the date in ISO-format, i.e. exactly in the format the OP requested. ... It is rare to need to be database independent. ... Sure, but again, there are moments, where a PreparedStatement ... The string is created by java.sql.Date, ...
    (comp.lang.java.programmer)
  • Re: [PhP - dB] About Formatting a Date Result
    ... In the MySQL database the field is set to date not timestamp as you ... foresight has stored a string date instead of a timestamp, ... and can format your date to that used, in the config files, for any user ...
    (php.general)
  • Re: Getting entries from an SQL database with datetime parameter
    ... format is what you want. ... funtion to convert date string into date time accordig to your needs. ... your database, you will run into troubles comparing date to string. ... > hard coded a query to populate the datagrid, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Manipulation of strings query
    ... I have received the data in an excel spreadsheet which contains the names in ... that I could enter it as 2 fields in a database and I'm certainly not doint ... The problem with the string input is that users will not be entering the ... > cintains names in the format LASTNAME, ...
    (microsoft.public.inetserver.asp.general)
  • Re: [PHP] Date/time format?
    ... Jason Pruim wrote: ... 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". ...
    (php.general)