* Abdul Wahab Dahalan <wahab(at)mimos(dot)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