Re: Convert input to Unix Timestamp

eclipsme wrote:

What is the suggested best ways to accept a date in a form that will
be input into a table as a timestamp? I only care about the
year-month-day, not the time.

My question would be: if you only care about year-month-day, why do you
want to store the data as a timestamp? Why not simply use a date field?

2008-11-16

If you are worried about varied input by users, use three separate
fields on your form and combine them before storage.

Enter date: Year [ ] Month [ ] Day [ ]

or similar.

--
-bts
-Friends don't let friends drive Windows
.

Relevant Pages

  • Re: SQL Losing Data
    ... that took care of the issue with the "record has been changed" error ... I'm sure having the timestamp field will take care of that other ... This issue is more likely due to using ODBC or some ... > data types. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Store SQL Timestamp locally for comparison
    ... I don't care about the actual data of the timestamp. ... about is the MAX value of the timestamp fields. ... OK I understand what you wish to do, but I would still recommend downloading ...
    (microsoft.public.access.modulesdaovba)
  • Help !! Im stuck in time !! :)
    ... Nope, I'm not a time traveller, but I do have something related to time ... functions I can't get my head 'round. ... I have to convert a timestamp to a humanly readable date/time. ... if you care to help, ...
    (microsoft.public.excel)
  • Re: Convert input to Unix Timestamp
    ... eclipsme wrote: ... if you only care about year-month-day, ... do you want to store the data as a timestamp? ... -Friends don't let friends drive Windows ...
    (alt.php)
  • Re: Convert input to Unix Timestamp
    ... eclipsme wrote: ... input into a table as a timestamp? ... I only care about the year-month-day, ... You can always massage the format internally before putting it in the database. ...
    (alt.php)