year to date conversion

[sgxbytes]

hi ,

i have a string sYear = 2008;
i need search from the database the results which are in the year 2008.

so how can i convert 2008 to this format

sDateFrom = "2008-01-01";
sDateTo = "2008-12-31";

thanks in advance...
raj

[JosAH]

hi ,

i have a string sYear = 2008;
i need search from the database the results which are in the year 2008.

so how can i convert 2008 to this format

sDateFrom = "2008-01-01";
sDateTo = "2008-12-31";

thanks in advance...
raj

If you just want String representations of the first and last day of the year you can
do this:

int year= ... ;
String sDateFrom= year+"-01-01";
String sDateTo= year+"-12-31";

Otherwise have a look at the (Gregorian)Cale ndar class.

kind regards,

Jos

[N002213F]

Most DBs now support date parsing in the queries. Some to_char for Oracle. check DB documentation as well.