RE: [firebird-support] Converting dates and the ISO-8601 format

2018-11-09 Thread i...@synapsesoftware.co.uk [firebird-support]
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

Re: [firebird-support] Converting dates and the ISO-8601 format

2018-11-09 Thread i...@synapsesoftware.co.uk [firebird-support]
Thanks very much Helen, a lot for me to digest here . Kind Regards,, Dave.

Re: [firebird-support] Converting dates and the ISO-8601 format

2018-11-10 Thread i...@synapsesoftware.co.uk [firebird-support]
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)

Re: [firebird-support] Converting dates and the ISO-8601 format

2018-11-10 Thread i...@synapsesoftware.co.uk [firebird-support]
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

Re: [firebird-support] Converting dates and the ISO-8601 format

2018-11-11 Thread i...@synapsesoftware.co.uk [firebird-support]
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,

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-12 Thread i...@synapsesoftware.co.uk [firebird-support]
Yes but in the scenario you describe - all computers are on the same network. I need to be able to connect to a remote server. I have mobile devices that need to communicate with the database (over a mobile network.) So unfortunately, I dont think I could manage with the embedded approach,

Re: ODP: [firebird-support] Converting dates and the ISO-8601 format

2018-11-11 Thread i...@synapsesoftware.co.uk [firebird-support]
Because I need a true client /server arrangement - from what I can see the embedded solution is really only for peer to peer connections on a local system. You cannot connect remotely or share data on a central server (there are also security restrictions from what I can see,)