SQL 014 SELECT DATE, TIME and TIMESTAMP {yahooanswerstitle}

Posted by: fcwgroup on August 10, 2013 Under: |

SQL 014 SELECT DATE, TIME and TIMESTAMP

Explains an overview of SQL DATE, TIME and TIMESTAMP. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL,…
Video Rating: 4 / 5

Follow me on Twitter @ http://twitter.com/tktutorials Check out my website @ http://www.timkipptutorials.com In this tutorial we will be converting a standar…
Video Rating: 5 / 5

4 Comments/Reviews

  • dashbyictfd says:
    August 10, 2013 at 1:40 pm

    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?

  • timkipptutorials says:
    August 10, 2013 at 1:45 pm

    YOU’RE WELCOME! 😛

  • Robert Holden says:
    August 10, 2013 at 1:52 pm

    THANK YOU!!!

  • Marc Solèr says:
    August 10, 2013 at 2:26 pm

    how about converting a european formatted date, like (DD/MM/YY) to the correct timestamp?

Powered by Yahoo! Answers