Home » U++ Library support » U++ SQL » SqlFormat() bug with Date and Time types
SqlFormat() bug with Date and Time types [message #9603] |
Sun, 20 May 2007 15:03 |
zsolt
Messages: 698 Registered: December 2005 Location: Budapest, Hungary
|
Contributor |
|
|
SqlFormat() generates some trash characters with Date and Time arguments.
As a result, you can not use dates and times in your SQL queries.
Here is the testcase:
#include <Core/Core.h>
#include <Sql/Sql.h>
using namespace Upp;
CONSOLE_APP_MAIN
{
Date sysdate = GetSysDate();
String s = SqlFormat(sysdate);
Cout() << "Todays date is: " << s;
while(1)
Sleep(1000);
}
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Jun 08 08:12:11 CEST 2024
Total time taken to generate the page: 0.01401 seconds
|