pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: panjas51@yahoo.fr
To: pgsql-sql@postgresql.org
Subject: [CHALLANGE] Add seconds to a date
Date: 25 Feb 2002 08:16:06 -0800
Message-ID: <3c1b889f.0202250816.298b7afd@posting.google.com> (raw)

I tried to make a PLSQL (oracle) function in order to add some seconds
to a specified date:

Let's take a exemple:
New_date=sec2date(#2002-02-02#, 100),
this should add 100 seconds to the entered date:
this should then return "2002-02-02 00:01:40".

Attention to the lead year.

If any one wants to take this challage or propose some quick wins
idees



view thread (2+ messages)  latest in thread

Message-ID: <3c1b889f.0202250816.298b7afd@posting.google.com>
Permalink:  ../3c1b889f.0202250816.298b7afd@posting.google.com/
Also on:    postgresql.org/message-id/3c1b889f.0202250816.298b7afd@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: panjas51@yahoo.fr
  Subject: Re: [CHALLANGE] Add seconds to a date
  In-Reply-To: <3c1b889f.0202250816.298b7afd@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox