title: Oracle convert Date to Number
body: <p>I want to  convert date to number in oracle 11g .</p>
  
  <p>The date is stored in (12/03/2013 12:23:00).</p>
  
  <p>I want to convert this to Number(The date corresponding number value).
  As in java we convert date to long .</p>
  
  <p>I want the same to be done here .</p>
  
  <pre><code>    Calendar c = Calendar.getInstance();
      c.set(2013, 05, 23, 0, 0, 0);
  
      Date date = c.getTime();
      System.out.println("Date is  " + date);
      long longDate = date.getTime();
      System.out.println("Date as long :" + longDate);
      Date d = new Date(longDate);
      System.out.println("Converted Date :" + d);*
  </code></pre>
  
  <p>The Output is :</p>
  
  <p>**Date is  Sun Jun 23 00:00:00 SGT 2013</p>
  
  <p>Date as long :1371916800981</p>
  
  <p>Converted Date :Sun Jun 23 00:00:00 SGT 2013**</p>
  
  <p>Now I want to store value as 1371916800981 </p>