Selecting with DATE_FORMAT

[lhg1]

Hi

I want to select everythin from a specifik day. from a datetime field.

SELECT * FROM `prodlog` 
WHERE DATE_FORMAT(`starttid`, '$Y-$m-$d') = '2007-04-10'

It just does not give me the enteryes in the datebase with this date.

/lhg

 

[sleipnir214]

I think it would be simpler for you to use date() instead of date_format(). Date() extracts the date part of a datetime field, and supplies that date in the standard MySQL format, YYYY-MM-DD.

Anyway, read the MySQL online manual entry for date_format() (link). You'll find that your dollar-signs are not the right symbol to use.



Want the best answers? Ask the best questions! TANSTAAFL!