X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3C644D1B215 for ; Mon, 14 Jun 2004 11:31:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06736-06 for ; Mon, 14 Jun 2004 14:31:11 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id E35FDD1B269 for ; Mon, 14 Jun 2004 11:31:05 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 855B32BD64; Mon, 14 Jun 2004 16:31:07 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25520-07; Mon, 14 Jun 2004 16:31:05 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 98FB42BD55; Mon, 14 Jun 2004 16:31:04 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 92BE1D9E83; Mon, 14 Jun 2004 16:31:04 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 25F5097642; Mon, 14 Jun 2004 16:31:04 +0200 (SAST) Date: Mon, 14 Jun 2004 16:31:01 +0200 From: Stef To: "Eric Lemes" Cc: Subject: Re: Datetime problem Message-Id: <20040614163101.5ddd23d3@svb.ucs.co.za> In-Reply-To: References: X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Mon__14_Jun_2004_16_31_01_+0200_rltH4IUULivryACo" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/105 X-Sequence-Number: 18050 --Signature=_Mon__14_Jun_2004_16_31_01_+0200_rltH4IUULivryACo Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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 : =3D> Hello there, =3D>=20 =3D> I'm with a little trouble with postgresql and date/time conversions: =3D>=20 =3D> - select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS') =3D>=20 =3D> the output is: =3D>=20 =3D> - 2004-10-09 23:00:00-03 =3D>=20 =3D> Anybody can help me? =3D>=20 =3D>=20 =3D> []'s =3D>=20 =3D> Eric Lemes de Godoy Cintra =3D> Analista de Sistemas L=EDder =3D> Zanthus Sistemas e Equip. Automa=E7=E3o S/A =3D> Desenvolvimento de Software =3D>=20 =3D>=20 =3D>=20 =3D> eric.lemes@zanthus.com.br =3D> Fone: 55(11) 3750-7077 =3D>=20 =3D>=20 =3D>=20 =3D> --- =3D> Outgoing mail is certified Virus Free. =3D> Checked by AVG anti-virus system (http://www.grisoft.com). =3D> Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004 =3D>=20 --Signature=_Mon__14_Jun_2004_16_31_01_+0200_rltH4IUULivryACo Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQM22qLoLc+HYd7LFAQKnqQQApHm6ol2A0yfpXloC2aqsPHYxTD1L2zdK h9BqKCsesVnZkaIM8IULXlPEJY3B82p+EVt4BsFaiIIbNxW1cCWYoroG7XTgXsbX Xmvx8tI1+JcIKQhySwpX6Xrk2EfbjBgZJmcbGbnabN/fdLyfoJHnIUt/XciAQeD4 w+tv64FKuHE= =5ASt -----END PGP SIGNATURE----- --Signature=_Mon__14_Jun_2004_16_31_01_+0200_rltH4IUULivryACo--