Problem using curdate() with mysql ?

[David]

Hi,

I have an asp page running from a mysql db.
A line in my asp code runs as follows:

.........WHERE ShipDate >= curdate()

This displays the data until 'shipdate' (from the database) is less
than curdate(). The problem I have is that I need the data to appear
until 7 days after the shipdate. I have tried things like curdate()+7,
but this does not work. I have also tried Shipdate+7, but this returns
incorrect records from the past ?
Appreciate your help

David

[Bart Van der Donck]

da***@scene-double.co.uk (David) wrote in message news:<c1**************************@posting.google. com>...

Hi,

I have an asp page running from a mysql db.
A line in my asp code runs as follows:

........WHERE ShipDate >= curdate()

This displays the data until 'shipdate' (from the database) is less
than curdate(). The problem I have is that I need the data to appear
until 7 days after the shipdate. I have tried things like curdate()+7,
but this does not work. I have also tried Shipdate+7, but this returns
incorrect records from the past ?

You can't trust returned date values from non-valid input.
You probably want someting like
DATEADD("2000-12-01",INTERVAL 7 DAY)

Also see:
http://www.mysql.com/doc/en/Date_and...functions.html

Bart

[Bart Van der Donck]

da***@scene-double.co.uk (David) wrote in message news:<c1**************************@posting.google. com>...

Hi,

I have an asp page running from a mysql db.
A line in my asp code runs as follows:

........WHERE ShipDate >= curdate()

This displays the data until 'shipdate' (from the database) is less
than curdate(). The problem I have is that I need the data to appear
until 7 days after the shipdate. I have tried things like curdate()+7,
but this does not work. I have also tried Shipdate+7, but this returns
incorrect records from the past ?

You can't trust returned date values from non-valid input.
You probably want someting like
DATEADD("2000-12-01",INTERVAL 7 DAY)

Also see:
http://www.mysql.com/doc/en/Date_and...functions.html

Bart

[Bart Van der Donck]

da***@scene-double.co.uk (David) wrote in message news:<c1**************************@posting.google. com>...

Hi,

I have an asp page running from a mysql db.
A line in my asp code runs as follows:

........WHERE ShipDate >= curdate()

This displays the data until 'shipdate' (from the database) is less
than curdate(). The problem I have is that I need the data to appear
until 7 days after the shipdate. I have tried things like curdate()+7,
but this does not work. I have also tried Shipdate+7, but this returns
incorrect records from the past ?

You can't trust returned date values from non-valid input.
You probably want someting like
DATEADD("2000-12-01",INTERVAL 7 DAY)

Also see:
http://www.mysql.com/doc/en/Date_and...functions.html

Bart