working with dates in SQL
Hi guys, looking for help with a problem with a small database I am setting up.
My dbase has only 2 tables which are
Employee ID (primary key)
NPK (foreign Key)
UKCC Table -
NPK (primary key)
UKCC expiry date
No Of day worked
PD review date
Now the problem I have is when creating a query to 'flag up' expiry dates 30 day before it does expire. I have no problems in cretaing the SELECT statement or FROM statement (as is always the case), and most of the WHERE statement i.e. linking the tables.
I know I cannot just subtract a integer from the expiry date, this is where I am struggling.
Any help would be greatly appreciated.
SQL Server? Take a look at the DATEDIFF function mate...
By David Croft in forum Database
Last Post: 08-13-2003, 01:45 PM
By Eric Litwin in forum VB Classic
Last Post: 09-24-2002, 11:13 AM
By James Lewis in forum VB Classic
Last Post: 04-02-2001, 07:44 AM
By francois in forum VB Classic
Last Post: 12-06-2000, 08:56 PM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 01:48 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL