SQL 014 SELECT DATE, TIME and TIMESTAMP

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,358
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 7, 2010

Explains an overview of SQL DATE, TIME and TIMESTAMP. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • I have my MySQL table, it only has 3 fields, id, fullname and datetime, I want it to work so that when someone submits the form the date and time are recorded alongside the name. No matter what I try all I get is the default 0000-00-00 00:00:00. Could you advise please?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more