09.11.2018 13:38, i...@synapsesoftware.co.uk [firebird-support] wrote:
> I really dont know how to format the results so that they appear "normal" for
> my region -
> ie the dd/mm/ format. I also am not sure where the problem originates.
Formatting of dates is a client-side job. You shoul
i...@synapsesoftware.co.uk wrote:
>I use Firebird primarily with Delphi and have had no problems with
>using and displaying dates (suitable for my country - UK.)
First thing to understand is that Firebird does not store dates
as strings. It can recognise string inputs for dates according
>>I use Firebird primarily with Delphi and have had no problems with using and
>>displaying dates >>(suitable for my country - UK.)
You can use this in your select statements for php:
f_dayofmonth(CREATEDATE)||'.'||f_month(CREATEDATE)||'.'||f_year(CREATEDATE)
CREATEDATE
format the PHP as
Yeah thanks Alan - I am currently using something similar..
extract(day from COLLECT_DELIVER_DATE)||'/'||extract(month from
COLLECT_DELIVER_DATE)||'/'||extract(year from COLLECT_DELIVER_DATE) as
COLLECT_DELIVER_DATE
Just a bit "wordy" / "verbose" and a bit shocked that you have to go to
Thanks very much Helen, a lot for me to digest here .
Kind Regards,,
Dave.
On 9-11-2018 13:38, i...@synapsesoftware.co.uk [firebird-support] wrote:
> I use Firebird primarily with Delphi and have had no problems with using
> and displaying dates (suitable for my country - UK.)
>
> However, it seems to be a big problem with Firebird and dates when
> working with PhP wit
Fantastic! Works a treat! Wow, wonder how many other people are going to be
tripped up by this ! ?
Thanks a lot Mark (and all those who responded)
Woops! Spoke to soon, changing the setting in the PHP.ini did not change
anything. Never mind, at least I know where to look . I will ask in some php
forum,
Thanks anyway..
Cheers
On 10/11/2018 11:19, i...@synapsesoftware.co.uk [firebird-support] wrote:
> Fantastic! Works a treat! Wow, wonder how many other people are going to
> be tripped up by this ! ?
There is a list for firebird users on php firebird-...@yahoogroups.com
It is true that Firebird does not perhaps get th
ok thanks Lester, I will head over there and see whats happening. I like
firebird a lot and have used it for years so Im kind of invested in it. In
hindsight, perhaps - perhaps I should have gone with MySql (seems like everyone
else has :))
You are right about it not getting much love, tryin
10 matches
Mail list logo