csvjdbc icon indicating copy to clipboard operation
csvjdbc copied to clipboard

Add a TO_CHAR(date/timestamp, format) SQL function

Open simoc opened this issue 2 years ago • 0 comments

Add an SQL function to convert a date or timestamp to a string.

The java.time.format.DateTimeFormatter class will be used to do the conversion and format will be a pattern used by java.time.format.DateTimeFormatter.

Also use the CsvJdbc "timeZone" and "locale" database connection properties when converting the date or timestamp, if set.

simoc avatar Oct 20 '23 19:10 simoc