dates & now()

[Anon]

Hi,

What appears to be the problem with the fwg query:

select code,date from multimedia_header where rubrica=87 and now() >
'08-03-2002 13:10:53' and date IS NOT NULL

The records returned includes those earlier than 08-03-2002 13:10:53 too..

pl help.. thnx in adv,

sands

[[deleted]]

now() > '08-03-2002 13:10:53'

Look at that bit...

what does it say?

it says "get all records where the current time is later than time '08-03-2002 13:10:53'
"

I guess you want to use

date > '08-03-2002 13:10:53'