MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2005

RE: Current Date in Query



fixed

I think they're all system date - the help says the current whatever of the 
system. Have not tested, however.

-------------- Original message -------------- 

> 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/ . 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
> 





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact