Re: Convert input to Unix Timestamp

eclipsme wrote:

eclipsme wrote:
Beauregard T. Shagnasty wrote:
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

I don't actually know. Is it difficult to convert a table that has
data in the timestamp format to date?

Wait one. You say "date in a form that will be input into a table". Why
would you even need to convert it to a timestamp?

My mistake. I just looked and found that I did not use timestamp. It
is a date field. Thanks for asking, though.

So it *is* a date! It should look like this then: 2008-11-16

Next question: there is no question, correct?

--
-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)
  • Re: Convert input to Unix Timestamp
    ... eclipsme wrote: ... if you only care about year-month-day, ... want to store the data as a timestamp? ... -Friends don't let friends drive Windows ...
    (alt.php)
  • 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: ... 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)