oracle help? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

oracle help?

oracle help?# Database - 数据库

b*e2000-05-30 07:05

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*k2000-05-30 07:05

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*e2000-05-30 07:05

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*k2000-05-30 07:05

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