Menu
Community /Pin to ProfileBookmark
@NogDogDec 21.2006 — #You could do something like this to insert a date:
@NogDogDec 21.2006 — #Definitely use a DATE or DATETIME field type, as that is the type of data you are representing. You can then compare and/or sort values easily within your SQL, such as:
Also, there are a whole bunch of[url=http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html]date and time functions[/url] you can use in your queries.
MySQL Date/Time
I am fairly new to both MySQL and PHP but I have some usage down and I am pretty good with database and programming logic. I am just curious before I set up my database about the code that does this (as I know it exists, I am just not familiar with it).
I used to use separate date year and month fields in my database and then set up specific queries based on the values of these fields. However, since I just need to get these values out, how can I do this if I just put values in all as one DATETIME or TIMESTAMP field…..thanks in advance.
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogDec 21.2006 — #You could do something like this to insert a date:[code=php]
// assume you've populted the variables $year, $month, and $day from your form inputs:
$date = sprintf('%04d-%02d-%02d', $year, $month, $day);
$sql = "INSERT INTO table_name (date_field) VALUES('$date')";
$result = mysql_query($sql) or die("Query failed: $sql - ".mysql_error());
[/code]0
@NogDogDec 21.2006 — #Definitely use a DATE or DATETIME field type, as that is the type of data you are representing. You can then compare and/or sort values easily within your SQL, such as:[code=php]
$start = '2006-12-01';
$end = '2007-01-31';
$sql = "SELECT * FROM table_name WHERE date_field BETWEEN '$start' AND '$end' ORDER BY date_field";
$result = mysql_query($sql);
[/code]Also, there are a whole bunch of