Thread: How to compare dates?
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.
* Abdul Wahab Dahalan <wahab@mimos.my> [17.03.2003 10:36]: > 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. use to_date and to_char functions, refer to para 6.7 of PostgreSQL User's Guide. -- Victor Yegorov
> > 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 > select to_char(timestamp '2003-03-16 11:29:23.567417+08','DD.MM.YYYY'); to_char ------------16.03.2003 (1 row) if that is what you wanted to know. Regards, Christoph
On Mon, 17 Mar 2003, Abdul Wahab Dahalan wrote: > 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 If you need to compare pgsql timestamp (unix time + micros) with java.util.Date (unix time), then you only need the compare() method. Note that java.sql.Timestamp extends java.util.Date. > > Any help very much appriciated > Thanks. > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr