 |
 |
Archives of the TeradataForum
Message Posted: Tue, 18 Oct 2005 @ 11:29:58 GMT
| Subj: | | Re: Date Fomat Problem in Macro between V2R5 and |
| |
| From: | | Dieter N?th |
Ankit Matkar wrote:
| | I got to know through documentation that this is due to the default date format setting difference between the Production and development.
Is there anyway I can override the default database setting at user level? | |
The easiest way is to use ANSI dates instead of a string which has to be casted to a date:
EXECUTE PORTFOLIO(DATE '2005-07-15',DATE '2005-03-15')
Dieter
| |
