oracleʱ¼äת»¯

COLLECTTIME
1262275200
1262275200


ÈçºÎ½«ÒÔÉÏOracleÖеÄʱ¼äת»¯ÎªYYYY-MM-DD HH:MM£¬ÒÔÉϵÄʱ¼äÊǶþ½øÖƱíʾ£¬»¹ÊÇʲô£¿·Ç³£¸Ðл

---

mark!

---

ÊÇ´Ó1970Ä꿪ʼµ½Ä³¸öʱ¼äËù¾­¹ýµÄÃëÊý£¬ËùÒÔ¡£¡£¡£¡£

---

¼ÇÒäÖеģ¬²»ÖªµÀ¶Ô²»¶Ô¹þ

---

Èç¹û³ý²»Íê???

---

È¥javaÀïÃæÓÃdateÀà°ÑËû¸øNew³öÀ´

public Date(long date)
Constructs a Date object using the given milliseconds time value. If the given milliseconds value contains time information, the driver will set the time components to the time in the default time zone (the time zone of the Java virtual machine running the application) that corresponds to zero GMT

---

ÒýÓÃ

Èç¹û³ý²»Íê???

ÓÐÎó²î¡£

---

ÒýÓÃ

SQL codeSQL>select to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:mi:ss')+1262275200/24/60/60from dual;

TO_DATE('1
----------
31-12ÔÂ-09

SQL> select to_char(to_date('1970-01-0100:00:00','YYYY-MM-DD HH24:mi:ss')+1262275200/24/60/60,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(TO_DATE('1970-01-0100:00:00','--------------------------------------2009-12-3116:00:00

 mark!

---

dual Õâ¸öÊÇʲô

---

ÒýÓÃ

dual Õâ¸öÊÇʲô

  α±í£¡ÄãÔÚÆäËû±í²é²»µ½µÄ¶«Î÷£¬¿ÉÒÔÔÚÕâÖÖ±íÖв鵽£¡