Subject | raw data format in SP |
---|---|
Author | vincent_kwinsey |
Post date | 2006-03-29T09:39:39Z |
assuming that tday, tmonth, tyear are integer
variables with valid values for date (e.g. '05','04','2006' resp.) -
can I rely that the follwing code in stored procedure will always (on
any OS, any language settings of OS or BDE or else) will assign to the
date (or timestamp) variable the value which I expect to be assigned
(unambiguously, e.g. I expect that the format for SQL is
always 'dd.mm.yyyy' - is it true?)?:
date_variabel=tday||'.'||tmonth||'.'||tyear;
if no - is any workaround how to convert 3 integer values into date
variables with valid values for date (e.g. '05','04','2006' resp.) -
can I rely that the follwing code in stored procedure will always (on
any OS, any language settings of OS or BDE or else) will assign to the
date (or timestamp) variable the value which I expect to be assigned
(unambiguously, e.g. I expect that the format for SQL is
always 'dd.mm.yyyy' - is it true?)?:
date_variabel=tday||'.'||tmonth||'.'||tyear;
if no - is any workaround how to convert 3 integer values into date