avatar
b*e
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
avatar
s*k
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

avatar
b*e
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

avatar
s*k
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。