Re: SQL Timestamp

BINGO
forgive me all. I haven't had my 6th cup of 24oz 7-11 coffee yet


Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/13/2008 08:57:17 AM:

Depends on your SYS vs. SQL setting...try this:

select current timestamp from sysibm/sysdummy1

On Wed, Aug 13, 2008 at 8:52 AM, Alan Shore <AlanShore@xxxxxxxx> wrote:

Hi Chuck
looks like I spoke too soon
I tried your suggestion
select current timestamp from sysibm.sysdummy1
and heres the response
Qualified object name SYSDUMMY1 not valid.
so I tried the following
select current timestamp from sysdummy1
and heres that response
SYSDUMMY1 in *LIBL type *FILE not found.



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/12/2008 05:28:09 PM:

Alan Shore wrote:

<<SNIP>>
Within an STRSQL session, how do you display the current timestamp?

To see what the value of the timestamp that was current at the

start

of the execution of the statement, the following statement:

select current timestamp from sysibm.sysdummy1

Regards, Chuck
--
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.

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

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