Select Date Matching Data

Hi all,

I want to select data from MS SQL Server DB that matches today's date.

However it also seeks to match time - I don't want time matched.

Here's my query...

$query = "SELECT id, name ".
                  "FROM misc ".
               "WHERE file_date = {fn NOW()}";

Hi,

Try the following

<PHP> $query = "SELECT id, name FROM misc WHERE file_date between convert(char(12), getdate()) AND convert(char(12), getdate() + 1)"; </PHP>

This will give you any record between today's date (at 00:00) and tomorrow's date (same time)