|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/17/2008 6:21:35 AM
Posts: 30,
Visits: 105
|
|
how 2 find out sysdate and systime in teradata
in oracle v used to give
select sysdate from dual;
like that
what is the coomand for teradata?
SHEEBA
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/11/2008 3:00:36 PM
Posts: 76,
Visits: 147
|
|
hi,
this should help - SEL DATE,TIME
thx,
-SN
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 1:34:31 PM
Posts: 225,
Visits: 530
|
|
Teradata also supports the ANSI/ISO standard SQL functions CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hey sheeba,
I believe that you also have worked in Oracle . Like Oracle , Teradata Also support ANSI SQL.
In teradata :- ( Sysdate from dual in Oracle --> replacement in teradata )
------------
SELECT CURRENT_DATE , CURRENT_TIME , CURRENT_TIMESTAMP ; -- Teradata
In teradata we dont have any Dual table like oracle.
I hope , I would have given the answer which you expected.
let me know if you need any more in detail
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/17/2008 6:21:35 AM
Posts: 30,
Visits: 105
|
|
|
|
|