Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date format in store procedure

Status
Not open for further replies.
jliang

jliang

MIS
Apr 26, 2004
30
US
Hi, I know the default date format in store procedure is 'yy/mm/dd', how can I change it to the format 'yyyy-mm-dd' in teradata store procedure?

Thanks very much
Jing
 
Sort by date Sort by votes
The date format defaults to the format used by the session which created the SP.
So you just have to specify "SET SESSION DATEFORM = ANSIDATE" before the "CREATE PROCEDURE ..."

Dieter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
137
tmcrouse
tmcrouse
Preshit
  • Locked
  • Question
Number of working days between two date fields
Replies
1
Views
157
johnherman
johnherman
2009luca
  • Locked
  • Question
date format
Replies
0
Views
102
2009luca
2009luca
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
135
jholl
jholl
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
293
Miguel93
Miguel93

Part and Inventory Search

Sponsor

Back
Top