Re: Convert User entered date and time to Unix Timestamp before inserting to database

From: scotty (scasti1_at_cox.net)
Date: 12/13/04 

Date: 13 Dec 2004 06:59:14 -0800

Thanks for the tip. There is a lot I'm not aware of. New to MYSQL.
In the recent past I created something that involved dates. I just now
changed the data definition you mentioned and it still works fine. The
field is now a DATETIME field but is being created with the same
TIMESTAMP. So it looks like this functions the same but is now
historical rather than the auto-update that you mention?

I look forward to going through my edit routines and inserting some of
the functions mentioned in these comments, where applicable, to make it
more concise where possible. Although I did not ask the original
question here, I appreciate the comments and hope that some of my
original comments helped as well.

Relevant Pages

  • Re: how to insert current date and time to db
    ... "Mullin" wrote ... > i use the following code, but the DateTime field at mysql is ... Sorry, I don't really know the types in MySql, but maybe DateTime is ... Prev by Date: ...
    (comp.lang.java.programmer)
  • PHP / MySQL time format
    ... I have a MySQL table with a datetime field that stamps the time the user ... $sql = "INSERT INTO table ...
    (comp.lang.php)
  • Re: Storing Dates in DB
    ... Works with mysql within a datetime field.. ... Regards ... Ray ...
    (comp.lang.php)
  • how to insert current date and time to db
    ... but the DateTime field at mysql is ... PreparedStatement stmt = connection.prepareStatement; ... Prev by Date: ...
    (comp.lang.java.programmer)
  • ASP SQL Server 2000 Date/Time Formating
    ... Date Formating when Inserting into SQL Server 2000 ... I'm trying to insert military time to a datetime field. ...
    (microsoft.public.inetserver.asp.db)