Versions Compared

Old Version 8

changes.mady.by.user Cortlandt _

Saved on

compared with

New Version 9

changes.mady.by.user Cortlandt _

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Extracting all the records for a full day, all the records for the entire day, requires a filter that compares just the date ('YYYY-MM-DD') or a date-time that starts at midnight ('YYYY-MM-DD 00:00:00.000').
First Issue: Extracting and loading records from a partial day may lead to unexpected results on reports.

...

Panel
bgColor#DEEBFF

  • GETDATE() returns the current system date-time ('YYYY-MM-DD hh:mm:ss.mmm').

  • DATEADD(DAY, - <n-days>, GETDATE()) resolves to the same time of day two days before.

...