RE: Epoch seconds

2004-12-14 Thread John Berman
Thanks for the responses Regards John Berman -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: 14 December 2004 14:43 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Epoch seconds Here's a SQL statement that converts dates to epoch time in Oracle. I&

RE: Epoch seconds

2004-12-13 Thread Weaver, Walt
, 'dd-mon-') ) from dual; --Walt > -Original Message- > From: John Berman [mailto:[EMAIL PROTECTED] > Sent: Monday, December 13, 2004 9:51 AM > To: [EMAIL PROTECTED] > Subject: Epoch seconds > Importance: High > > > Hi > > > I hav

Re: Epoch seconds

2004-12-13 Thread Roger Baklund
-MM-DD. I also have a start field and expire field I need to convert the start_date to Epoch seconds and place in start and convert the expire_date and place in expire. Why? In general it is better to calculate things on the fly when you need it, and only store the information once. You should

Epoch seconds

2004-12-13 Thread John Berman
Hi I have a table that has start_date and expire_date in the format: 2004-12-31 I also have a start field and expire field I need to convert the start_date to Epoch seconds and place in start and convert the expire_date and place in expire. I'm unsure how to convert and how to do this i