Hi Nicolas,
I don't know if anyone got back to you on this one. You can always
create your own function to do this. The java code would look something
like this:
publicstaticStringdayOfWeek( java.sql.Date date )
throws Exception
{
GregorianCalendarcalendar
SELECT CASE WHEN COL1 is NULL THEN0 ELSE1 END FROM MYTABLE
Regards,
AliNicolas Dufour [EMAIL PROTECTED] wrote:
HelloI try to put tests in select clause.I mean I have a field which can be null and I want to create a select which return 0 when the field is null and 1 in the other case.Is it
Thanks
Derby is really complete :)
However, I didnt find in the builtin function a way to retrieve the day
of the week of a date or a timestamp, I mean monday, tuesday ...and so on.
Is there such function anywhere ?
Nicolas
Suavi Ali Demir wrote:
SELECTCASE WHEN COL1 is NULL THEN 0