what is the right sql command to get day difference?
From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 03/27/04
- Next message: Michael Jacobs: "Re: how do I retrieve length of entry in access database"
- Previous message: Martin Plourde: "Re: Server Cursor with Joined Tables"
- Next in thread: Michael Jacobs: "Re: what is the right sql command to get day difference?"
- Reply: Michael Jacobs: "Re: what is the right sql command to get day difference?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 27 Mar 2004 15:31:22 +0100
Hi there,
I need to select those datasets that are older than a year.
I tried: "SELECT * FROM Abrechnung WHERE (ab_datum-date)>365
but nothing happened.
What should I do??
Thanks,
Pascal
- Next message: Michael Jacobs: "Re: how do I retrieve length of entry in access database"
- Previous message: Martin Plourde: "Re: Server Cursor with Joined Tables"
- Next in thread: Michael Jacobs: "Re: what is the right sql command to get day difference?"
- Reply: Michael Jacobs: "Re: what is the right sql command to get day difference?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]