Subject Re: [firebird-support] Re: Different separators for date and time
Author Milan Babuskov
Salvatore Besso wrote:
> And to complete the changes, what is the suggested time format (only hours
> and seconds)? I'm actually using HH.MM with a point as separator.

I use HH:MM or HH:MM:SS and colon as a separator. Once again, if you use the
point, it could get confused with some date, consider date 01.02.03 and time
01.02.03. If you use colon for time, it can never be mistaken to date. Also, I
believe Firebird uses point (dot) to separate milliseconds, like HH:MM:SS.mmm,
where mmm = milliseconds.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org