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.
Guten Tag Dalton Calford dalton.calf...@gmail.com [firebird-support],
there is a free but limited version of ibexpert available which supports all
current firebird versions
http://www.ibexpert.net/ibe/
IBExpert Developer Studio Personal Edition
> All the free firebird management tools are
>>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
2018-11-07 16:33 GMT+01:00, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] :
> 07.11.2018 16:28, Michal Kurczabinski michk...@gmail.com [firebird-support]
> wrote:
>> Firebird also doesn't support data partitioning, extended window
>> functions
>
>On the other hand transactions in
2018-11-07 19:06 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
> On 2018-11-07 16:28, Michal Kurczabinski michk...@gmail.com
> [firebird-support] wrote:
>> Firebird also doesn't support data partitioning, extended window
>> functions
>
> What are you really missing in
2018. 11. 08. 12:40 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
> And I use web-interface for this group, surprise ?
Vlad,
I can send the attachment privately. Which address?
Gabor
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
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
OK, there are multiple error reports in Flamerobin trackers about this and no
solution in more than 1.5 years. Flamerobin 9.2 works as expected, although it
does not support internal functions, but such feature is not necesary for
script execution. Apparently, Flamerobin is ceasing to exist.
All the free firebird management tools are falling by the wayside.
Flamerobin can not handle the new datatypes, does not show database
triggers, crashes with UTF8 in many areas etc.
FenixSQL is dead
FirebirdWebAdmin is based on the no longer supported php5
the list goes on.
Dbeaver is generic and
11 matches
Mail list logo