I`m no sure this is the right place for this question... but... I`m developing a web application with PHP/Interbase and the Systems administrator had to reinstall my tests database. After he reinstalled it somehow the configuration of the TIME type format fields changed to a 12 h with AM/PM instead of a 24h (11:00 PM / 23:00:00) which is making a huge difference to my php scripts... I don`t want to change all that I`ve already developed and I know that it is probabilly just a configuration feature that has to be changed. Does anyone knows how can I change the configurations of interbase? It is my first time working with it and I acctually don`t really deal with it... Any way...
Thank you...
TIME type format: 12 h with AM/PM -> 24 h
Please note that this forum is dedicated to IBDAC components, not the InterBase\Firebird servers.
As to your question, then you should know that InterBase\Firebird server stores and transmits to client date-time data in the numeric format (double precision float values), and then your client application (or Data Access layer) converts obtained numerics to strings. So I advice you to pay attention to your client-side routines rather than server-side settings.
As to your question, then you should know that InterBase\Firebird server stores and transmits to client date-time data in the numeric format (double precision float values), and then your client application (or Data Access layer) converts obtained numerics to strings. So I advice you to pay attention to your client-side routines rather than server-side settings.