X-Original-To: pgsql-sql@postgresql.org
Received: from filter.mimos.my (filter.mimos.my [192.228.137.70])
	by postgresql.org (Postfix) with ESMTP id ECC03475E82
	for <pgsql-sql@postgresql.org>; Mon, 17 Mar 2003 03:30:16 -0500 (EST)
Received: from ew.mimos.my (localhost.localdomain [127.0.0.1])
	by filter.mimos.my (8.11.6/8.11.6) with ESMTP id h2H8DqV18098
	for <pgsql-sql@postgresql.org>; Mon, 17 Mar 2003 16:13:52 +0800
Received: (from root@localhost)
	by ew.mimos.my (8.12.3/8.12.3) id h2H8U0rO072845
	for pgsql-sql@postgresql.org; Mon, 17 Mar 2003 16:30:00 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Received: from mimos.my (sol-wel197.nat.mimos.my [10.1.23.197])
	by ew.mimos.my (8.12.3/8.11.6) with ESMTP id h2H8U0eg072725
	for <pgsql-sql@postgresql.org>; Mon, 17 Mar 2003 16:30:00 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Message-ID: <3E758782.9913878A@mimos.my>
Date: Mon, 17 Mar 2003 16:29:54 +0800
From: Abdul Wahab Dahalan <wahab@mimos.my>
Reply-To: wahab@mimos.my
Organization: Mimos Berhad
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: How to compare dates?
X-scanner: scanned by Inflex 1.0.10 - (http://pldaniels.com/inflex/)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200303/380
X-Sequence-Number: 12419

How  do I compare this dates:

1. date( in timestamp) = 2003-03-16 11:29:23.567417+08

2. date created from java program like :

String format ="dd.MM.yyyy";
Date today = new Date();
SimpleDateFormat formatter = new SimpleDateFormat(format);
String todaysdate = formatter.format(today);

says the result is : todaysday = 17.03.2003

Any help very much appriciated
Thanks.