Hi,
systimestamp doesn't seem to be available under Oracle 8i (my configuration).
However, you can use :
select sysdate from dual
... to get a complete timestamp.
Andre Peterka a écrit :
Hello all
I am having a problem retrieving the current timestamp from the DB (in
this case oracl
m dual
SYSTIMESTAMP
12.12.2005 13:36:23,377940 +01:00
Cheers,
Andre
> -Ursprüngliche Nachricht-
> Von: Broderick, Kevin [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 12. Dezember 2005 13:34
> An: user-java@ibatis.apache.org
> Betreff: RE: Select timestamp from db
>
>
What is "systimestamp"? I ran that query in sql*plus
and Oracle didn't know what it was, perhaps from another DB ?
Cheers,
Kev
-Original Message-
From: Andre Peterka [mailto:[EMAIL PROTECTED]
Sent: 12 December 2005 12:27
To: user-java@ibatis.apache.org
Subject: Select ti
Hello all
I am having a problem retrieving the current timestamp from the DB (in
this case oracle):
select systimestamp from dual
I get the follwing error:
--- The error occurred while applying a result map.
--- Check the getDbDate-AutoResultMap.
--- Check the result mapping for th
