From: Stef <svb@ucs.co.za>
To: Eric Lemes <eric.lemes@zanthus.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: Datetime problem
Date: Mon, 14 Jun 2004 16:31:01 +0200
Message-ID: <20040614163101.5ddd23d3@svb.ucs.co.za> (raw)
In-Reply-To: <AIEBKHHFIIDLBADEGCPDIEKICAAA.eric.lemes@zanthus.com.br>
References: <AIEBKHHFIIDLBADEGCPDIEKICAAA.eric.lemes@zanthus.com.br>
Hello Eric,
Are you looking for something like :
select to_char(timestamp 'now','YYYY MM DD HH MI SS');
or the values in your example below :
select to_char(timestamp '20041010 00:00:00','YYYY MM DD HH MI SS');
Eric Lemes mentioned :
=> Hello there,
=>
=> I'm with a little trouble with postgresql and date/time conversions:
=>
=> - select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS')
=>
=> the output is:
=>
=> - 2004-10-09 23:00:00-03
=>
=> Anybody can help me?
=>
=>
=> []'s
=>
=> Eric Lemes de Godoy Cintra
=> Analista de Sistemas Líder
=> Zanthus Sistemas e Equip. Automação S/A
=> Desenvolvimento de Software
=>
=>
=>
=> eric.lemes@zanthus.com.br
=> Fone: 55(11) 3750-7077
=>
=>
=>
=> ---
=> Outgoing mail is certified Virus Free.
=> Checked by AVG anti-virus system (http://www.grisoft.com).
=> Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004
=>
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: svb@ucs.co.za, eric.lemes@zanthus.com.br
Subject: Re: Datetime problem
In-Reply-To: <20040614163101.5ddd23d3@svb.ucs.co.za>
* 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