how to find sysdate and time value

Tools & Utilities
Enthusiast

how to find sysdate and time value

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?
4 REPLIES
SN
Enthusiast

Re: how to find sysdate and time value

hi,

this should help - SEL DATE,TIME

thx,
Enthusiast

Re: how to find sysdate and time value

Teradata also supports the ANSI/ISO standard SQL functions CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP.

Enthusiast

Re: how to find sysdate and time value

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

Enthusiast

Re: how to find sysdate and time value

thanks