in_rapture wrote:

I know this is kind of a dumb question, but where does one find a nice list of the valid Firebird date format strings in the documentation? I have searched through the .pdf files on, as well as other online documentation and can't seem to find it anywhere.

Web searches have mostly just turned up forum postings that have one or maybe two formats shown followed by a comment to look at the documentation. I am dealing with an ancient system that has dates in several different formats and just would like to know my formating options to make conversion easier.

Helen Borrie answers:

There is a comprehensive list on p145 of The Firebird Book. Because I don't think it is to be found in any other single document, I have just extracted all the date literal tables from the source of Chapter 10 and put it up here.

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list