b****e
发帖数: 1275 | 1 is there an oracle function that does what the perl localtime does?
ie. translate the epoch date (long int) to a date string like mm/dd/yyyy?
thanks |
s*k
发帖数: 144 | 2
SELECT TO_CHAR(SYSDATE,'DD/MON/YYYY') FROM sys.dual;
hope that works
【在 b****e 的大作中提到】
: is there an oracle function that does what the perl localtime does?
: ie. translate the epoch date (long int) to a date string like mm/dd/yyyy?
: thanks
|
b****e
发帖数: 1275 | 3 no no no.. i am not asking for that.. i need a function that
translates epoch time (sec from jan 1 1970) to MMDDYYYY kind
of format. to_char doesn't work
thanks
【在 s*k 的大作中提到】
:
: SELECT TO_CHAR(SYSDATE,'DD/MON/YYYY') FROM sys.dual;
: hope that works
|
s*k
发帖数: 144 | 4 As far as I know, there is no built-in function
for Oracle8 to support your convertion though
the time stored in oracle is also a special kind
of integer.
So could you explain your scenario a little more so that
we may find a way to walk around your problem?
【在 b****e 的大作中提到】
: no no no.. i am not asking for that.. i need a function that
: translates epoch time (sec from jan 1 1970) to MMDDYYYY kind
: of format. to_char doesn't work
: thanks
|
