Feature #515

Add CURRENT_TIME/DATE to SqlExp

Added by Miroslav Fidler over 7 years ago. Updated over 7 years ago.

Status:ApprovedStart date:09/12/2013
Priority:NormalDue date:
Assignee:Jan Dolinár% Done:

100%

Category:SqlSpent time:-
Target version:-

Sql.patch Magnifier (1.18 KB) Jan Dolinár, 09/23/2013 02:43 PM

History

#1 Updated by Jan Dolinár over 7 years ago

  • File Sql.patchMagnifier added
  • Category set to Sql
  • Status changed from New to Patch ready
  • Assignee set to Miroslav Fidler
  • % Done changed from 0 to 100

See attached patch please. I added:

SqlVal SqlCurrentDate();
SqlVal SqlCurrentTime();
SqlVal SqlCurrentTimestamp();

Tested with MySql and SQLite. Should also work with Postgres, Oracle and MSSQL, according to their docs.

#2 Updated by Miroslav Fidler over 7 years ago

  • Status changed from Patch ready to Ready for QA
  • Assignee changed from Miroslav Fidler to Jan Dolinár

After some thinking, I have used only single SqlCurrentTime that returns SQL timestamp. I guess this way it is more consistent with U++ Date/Time... however I can be easily persuaded the other way.

#3 Updated by Jan Dolinár over 7 years ago

  • Status changed from Ready for QA to Approved

Miroslav Fidler wrote:

After some thinking, I have used only single SqlCurrentTime that returns SQL timestamp. I guess this way it is more consistent with U++ Date/Time... however I can be easily persuaded the other way.

Ok, it makes sense.

Also available in: Atom PDF