day today query?

homer.favenir · #1 (**permalink**) 03-15-08, 03:47

hi,
what is the syntax for getting the day today?
like monday, tues....

thanks

healdem · #2 (**permalink**) 03-15-08, 05:39

personally I'd do that in the presentation level, but you almost certainly can do that in SQL... have you looked at the manual?

r937 · #3 (**permalink**) 03-15-08, 08:49

i am regularly, and totally, shocked and surprised that people need a database for this type of thing

today is saturday, dude

websitehacks · #4 (**permalink**) 03-15-08, 15:25

I think the OP is trying to insert the day into the database. If that isn't what you want, try being a bit more clear. Otherwise, to insert the day that the script was executed by the user, try this:

1-Define today

Code:

$today = date("l");

2-Insert this into the db

Code:

//your db connection goes here

$query=mysql_query("INSERT into TABLE (theday) values ('$today')");

homer.favenir · #5 (**permalink**) 03-19-08, 15:10

thanks guys.

i just want to get the records with the current date. no more selections or searchings...

r937 · #6 (**permalink**) 03-19-08, 15:14

you say "records with the current date"

and i say "which column, what datatype, and how do the values get inserted?"

homer.favenir · #7 (**permalink**) 03-19-08, 15:58

it is just a query that will return records with current date.

r937 · #8 (**permalink**) 03-19-08, 17:04

records with current date in which field?

homer.favenir · #9 (**permalink**) 03-19-08, 19:18

date field with datetime datatype...

r937 · #10 (**permalink**) 03-19-08, 19:46

excellent

Code:

select ...
  from ...
 where date_added = CURRENT_DATE

Internet Services

Web Development

Digital Marketing

Consumer Tech