pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Joseph Syjuco <joseph@asti.dost.gov.ph>
To: pgsql-sql@postgresql.org
Subject: getting the current date
Date: 17 Oct 2002 09:11:44 +0000
Message-ID: <1034845906.2085.1.camel@Falcon> (raw)


how can i get the current date (without the time part) in sql.  I tried
doing a select now() but it also gives me the time part 
TIA
joseph

view thread (3+ messages)

Message-ID: <1034845906.2085.1.camel@Falcon>
Permalink:  ../1034845906.2085.1.camel@Falcon/
Also on:    postgresql.org/message-id/1034845906.2085.1.camel@Falcon

copy link · copy postgr.es

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: joseph@asti.dost.gov.ph
  Subject: Re: getting the current date
  In-Reply-To: <1034845906.2085.1.camel@Falcon>

* 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