Mysql Functions CONVERT_TZ()

[Sheldon D'Souza]

We need to do some time zone conversions on client side, wanted to know how the mysql CONVERT_TZ() function can be used in the select.

[Lukas Eder]

Hi Sheldon,

Right now, jOOQ doesn't have out-of-the-box support for that function, but you can easily build support yourself by using jOOQ's plain SQL API. See:

http://www.jooq.org/doc/latest/manual/sql-building/plain-sql

For example:

public static Field<String> convertTz(Field<String> ts, String from, String to) {

    return DSL.field("convert_tz({0}, {1}, {2})", String.class, ts, DSL.val(from), DSL.val(to));

}

Hope this helps,

Lukas

2016-09-26 13:00 GMT+02:00 Sheldon D'Souza <she...@sminq.com>:

We need to do some time zone conversions on client side, wanted to know how the mysql CONVERT_TZ() function can be used in the select.

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.