babelfish_extensions
babelfish_extensions copied to clipboard
Published
20 hours ago •
babelfish-for-postgresql
babelfish-for-postgresql
FORMAT() function does not handle 'F' mask
For the FORMAT() function, Babelfish supports the lowercase 'f' mask, but not the uppercase 'F':
1> select FORMAT(getdate(), 'HH:mm:ss.ffff')
2> go
format
----------------------------------------------
14:33:49.2330
1> select FORMAT(getdate(), 'HH:mm:ss.FFFF')
2> go
format
----------------------------------------------
14:33:49.FFFF
