Hi,
I am an employee of Concatel that recently adquired HXTT Acces v3.1.
I have problems when I try to comparate two dates.
Please can you send me, some examples of comparate dates and parsing dates in
java code please.
Thanks
Toni Almagro
jantonio.almagro@concatel.com
Concatel Vanture Team
Av. Ports d'Europa,100 - 08040 Barcelona (Spain)
tel. +34.93.567.97.10
fax +34.93.567.97.11
|
For instance,
where date1>{d '2006-01-30'}
where date1
...
What's your wrong sample?
|
Hi,
This is my code. I am trying to select the max(valor1) with the
clausule table.variable >= {ts 'date'}. The format of data is
yyyy-mm-dd hh:mm:ss.
SELECT MAX(valor1) FROM ["+archive+"].DataCertificacio
WHERE (DCE_VPL_ID = 1 AND DCE_SIS_ID =5
AND DataCertificacio.DCE_Data >= {ts '"+valor+"'} )";
|
Your sql seem to be correct.
You should use System.out.println("SELECT MAX(valor1) FROM ["+archive+"].DataCertificacio
WHERE (DCE_VPL_ID = 1 AND DCE_SIS_ID =5
AND DataCertificacio.DCE_Data >= {ts '"+valor+"'} )");
to see what's valor. It need to be a string with "yyyy-mm-dd hh:mm:ss" format.
|
Main
webmaster@hxtt.com