Oracle中是否有任何方法可以从oracle中的unix时间戳中获取dd-mm-yyyy部分？
喜欢：
select to_char(my_timestamp,'ddmmyyyy') as my_new_timestamp from table
解决方法
鉴于此数据……
sql> alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss' 2 / Session altered. sql> select * from t23 2 / MY_TIMESTAMP -------------------- 08-mar-2010 13:06:02 08-mar-2010 13:06:08 13-mar-1985 13:06:26 sql>
..这只是将the time elapsed since 01-JAN-1970转换为秒的问题：
sql> select my_timestamp 2,(my_timestamp - date '1970-01-01') * 86400 as unix_ts 3 from t23 4 / MY_TIMESTAMP UNIX_TS -------------------- ---------- 08-mar-2010 13:06:02 1268053562 08-mar-2010 13:06:08 1268053568 13-mar-1985 13:06:26 479567186 sql>
