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.
>
