FR4 + Delphi + ADO + PostgreSQL timestamps

mat.taabskomat.taabsko
edited 1:32PM in FastReport 4.0
Hello everyone,

I'm just starting with FR4 and i find it very powerful. I'm facing some issues though.
We have a Delphi (2006) application with FR4.
I load a report and pass date variables.

In my PosgreSQL DB my date fields are 'TimeStamp without timezone' typed.
I tried passing my variables as TDateTime, TimeStamp, String.
Nothing seems to work. I can see correctly the variable values but when i want to filter with them in an TADOQuery SQL (ex ' myTable.myDateField > my variable ') it doesn't work.

Does anyone already have to deal with timestamp field in postgres?

Thanks

Comments

  • technisofttechnisoft
    edited 1:32PM
    Have you tried to use casting the date or column value?
  • mat.taabskomat.taabsko
    edited 1:32PM
    technisoft wrote: »
    Have you tried to use casting the date or column value?

    In my query? I tried but maybe my syntax is wrong. How would you write it?
  • technisofttechnisoft
    edited 1:32PM
    mat.taabsko wrote: »
    mat.taabsko wrote: »
    Have you tried to use casting the date or column value?

    In my query? I tried but maybe my syntax is wrong. How would you write it?

    In Firebird it would be (I have no experience with PostGreSQL)

    CAST( <column> AS <DATATYPE> ) AS <castedColumn>

    e.g.

    CAST( DATE_TIME_STAMP_COLUMN AS DATE ) AS DATE_ONLY

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024