Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to previous message
zsolt is currently offline  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);
}

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQL "AS" for PostgreSQL fixed
Next Topic: PostgreSQL fieldname case bug
Goto Forum:
  


Current Time: Tue May 14 05:55:31 CEST 2024

Total time taken to generate the page: 0.02913 seconds