Hi,

> We have a lot of Oracle TO_DATE()

You could create a Java function. Example (not optimized):

create alias TO_DATE as $$
java.util.Date toDate(String s) throws Exception {
  return new java.text.SimpleDateFormat("yyyy.MM.dd").parse(s);
}
$$;
call TO_DATE('1990.02.03');

See also http://www.h2database.com/html/grammar.html#create_alias

> I did'n undesrtand is H2 windows service must be runnig or not

It doesn't.

> "session closed" [90067-128]

What is your database URL, and what is the exact exception message and
stack trace?

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to