Check these examples: http://geekswithblogs.net/SanjayU/archive/2006/04/14/75198.aspx
2009/5/19 Rob Wolfe <wolfe....@gmail.com> > > > > On May 19, 12:27 pm, Antonio <antonio.pie...@gmail.com> wrote: > > Hi, > > > > The date in the database is stored in this format YYYY-MM-DD- > > HH24:MI:SS > > During the select query, > > I would like to convert this date format in "Unix epoch". > > How can I manage the SQL query to make it? > > > > Thanks, > > > > Antonio > > Google is everyone's friend ... > > http://blogs.sun.com/mock/entry/converting_oracle_dates_to_unix > > Rob > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
