pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gonzo Rock <GonzoRock@Excite.com>
To: pgsql-sql@postgresql.org
Subject: Date Time Functions - ANSI SQL ?
Date: Sun, 29 Jul 2001 21:19:11 -0700
Message-ID: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> (raw)

Curious to know...

Are all the date time functions described in the pgSQL docs are ANSI-SQL or pgSQL extensions?

For Example in the Docs:
------------------------
4.7.1. EXTRACT, date_part

EXTRACT (field FROM source)

The extract function retrieves sub-fields from date/time values, such as year or hour. source is a value expression that evaluates to type timestamp or interval. (Expressions of type date or time will be cast to timestamp and can therefore be used as well.) field is an identifier (not a string!) that selects what field to extract from the source value. The extract function returns values of type double precision. The following are valid values: 

day
  The day (of the month) field (1 - 31) 

  SELECT EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40');
  Result: 16

Thanks all,




view thread (5+ messages)  latest in thread

Message-ID: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net>
Permalink:  ../3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net/
Also on:    postgresql.org/message-id/3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net

 · 

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: GonzoRock@Excite.com
  Subject: Re: Date Time Functions - ANSI SQL ?
  In-Reply-To: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net>

* 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