Re: SQL Timestamp -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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