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

2018-11-12 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>> Yes but in the scenario you describe - all computers are on the same network. No, you can have web server on e.g. shared hosting and you can connect to it from every place. You can show web page on your phone, tablet … Regards, Karol Bieniaszewski

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

2018-11-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.11.2018 15:10, i...@synapsesoftware.co.uk [firebird-support] wrote: > 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

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-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Please define local/remote here.For mee, it looks like this.On shared hosting i have web server e.g IIS. This web server operate locally with embeded Firebird server. Remote are only connections from clients to those web server. All is working for me without any problems.Regards,Karol

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,)

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

2018-11-11 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>>I trying to find a web host that will run a firebird server is very hard Why? Do you hear about embeded Firebird? I use FB embeded on the hosting environment without the problem Regards, Karol Bieniaszewski

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: [firebird-support] Converting dates and the ISO-8601 format

2018-11-10 Thread Lester Caine les...@lsces.co.uk [firebird-support]
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

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-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 Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

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-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 'Alan McDonald' a...@meta.com.au [firebird-support]
>>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

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

2018-11-09 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

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

2018-11-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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