|
Dwayne, These functions are available: CURRENT: (DATE) (TIME) (TIMESTAMP) (TIMEZONE) So if you need system date, you can probably substring it out of the timestamp. I'm assuming that the CURRENT(DATE) function pulls the job date. -mark Original Message: ----------------- From: Dwayne Allison Dwayne.Allison@xxxxxxxxxxxxxxxxxxxxxxxx Date: Mon, 21 Nov 2005 09:11:28 -0600 To: midrange-l@xxxxxxxxxxxx Subject: Current Date in Query Good Morning, I am setting up a query and was wonder if I could define a field with the system date? -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.