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
Re: SqlFormat() bug with Date and Time types [message #9604 is a reply to message #9603] Sun, 20 May 2007 15:21 Go to previous messageGo to previous message
zsolt is currently offline  zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary
Contributor
As a fast hack, I use this code in SqlCase.cpp
String SqlFormat(Date x)
{
	return FormatDate(x, "'YYYY-MM-DD'");
	//return MakeSqlValue(SQLC_DATE, x);
}

String SqlFormat(Time x)
{
	return FormatTime(x, "'YYYY-MM-DD hh:mm:ss'");
	//return MakeSqlValue(SQLC_TIME, x);
}



But I think, this should depend on current database handler.
 
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: Mon Aug 25 22:45:54 CEST 2025

Total time taken to generate the page: 0.05935 seconds