Hi Budi,

You can use ODBC generic functions.

SELECT { fn CONVERT( { fn NOW() }, SQL_CHAR) }

SELECT { fn CONVERT( myFieldDatetime, SQL_INTERVAL_HOUR_TO_SECOND ) }

SELECT { fn CONVERT( myFieldDatetime, SQL_INTERVAL_HOUR_TO_MINUTE ) }

ODBC Driver traslate this to specific Data Source SQL code.

But the ODBC drivers, that support the keywords SQL_INTERVAL_XXXXX
are little ( SQL Server not support this ).

You can try this, but i'm not sure it is formatting stable

SELECT { fn RIGHT({ fn RTRIM({ fn CONVERT( myFieldDatetime, SQL_CHAR ) })},7)}

Fabio