Feature #515
Add CURRENT_TIME/DATE to SqlExp
| Status: | Approved | Start date: | 09/12/2013 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | Jan Dolinár | % Done: | 100% | |
| Category: | Sql | Spent time: | - | |
| Target version: | - |
Sql.patch 
(1.18 KB)
History
#1 Updated by Jan Dolinár over 10 years ago
- File Sql.patch 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 10 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 10 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.