How to compare dates?

From: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to compare dates?
Date: 2003-03-17 08:29:54
Message-ID: 3E758782.9913878A@mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Victor Yegorov 2003-03-17 08:45:20 Re: How to compare dates?
Previous Message Manfred Koizar 2003-03-17 08:08:42 Re: create index right after create table not working?