Re: Convert input to Unix Timestamp

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?

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

Relevant Pages

  • Re: logging time spent on my website
    ... I store the timestamp in db ok thats cool. ... Thats why I was thinking of a endless loop. ... > you now have 2 items, last length of time, and current time stamp. ...
    (comp.lang.php)
  • 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)
  • Re: Optimistic Concurrency in a web app
    ... My question was more about how to handle and more specifically when to store the timestamp value: from the initial server postback, after an edit control is displayed to the user or finally when the user posts back. ... When I first display the label version of a field? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Data Base Interface Wizard update problem
    ... Excuse me what do you mean by timestamp field?In my access database i need a ... field of type date/time in order to store the date ... separate field with type timestamp? ...
    (microsoft.public.frontpage.client)
  • Re: Storing Dates in DB
    ... >>> What do you think is the best way to store Dates into a database? ... >> timestamp and then dateto format it as you wish. ... >> this is you are limited to the range of a unix timestamp which is ... Hence my note about the downside:) ...
    (comp.lang.php)