Current date in Teredata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Current date in Teredata
Hi,
Could you please suggest me how can I get current date if I am executing below Query in Teradata Enterprise stage.
Query :
SELECT
PREV_YR_DT,DATE
FROM cldr
This query works fine in SQL editor but when I am executing in Teradata enterprise stage its failing.
Is there any way to get Current Date through SQL?
Thanks
Sagar
Could you please suggest me how can I get current date if I am executing below Query in Teradata Enterprise stage.
Query :
SELECT
PREV_YR_DT,DATE
FROM cldr
This query works fine in SQL editor but when I am executing in Teradata enterprise stage its failing.
Is there any way to get Current Date through SQL?
Thanks
Sagar
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
All you've said so far is "it is failing" or "it failed"... why not post the error message(s) so we have some dang idea why it is failing?sagar deshmukh wrote:Any can help?
![Confused :?](./images/smilies/icon_confused.gif)
Since the SQL is apparently valid, have you checked with your official support provider? Perhaps it is a known issue...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers