Inserting TTime values in Symbian DB using SQL..

 

I had been trying to insert TTime values using SQL statements and had real tough time getting the SQL string right. Firstly there is a complete specification for how to format values in the SQL statement when inserting it into the database. You can find it here: Symbian OS guide >> System libraries >> Using DBMS >> DBMS rowsets >> DBMS SQL >> Supported SQL subset So while inserting the date values do not forget to insert the '#' around the TTime values. Here is some sample code to do the same :

view plaincopy to clipboardprint?

TBuf<50> dateStr; TTime homeTime; homeTime.HomeTime(); // Will convert it into the following format // MM/DD/YYYY hh:mm:ss AM/PM _LIT(KDateString3,"%M%D%Y%/0%1%/1%2%/2%3%/3 %-B%:0%J%:1%T%:2%S%:3%+B"); homeTime.FormatL(dateStr,KDateString3); _LIT(KSQLText,"INSERT INTO DateTest (Time) VALUES (#%S#)"); HBufC* sqlStr = HBufC::NewLC(1024); sqlStr->Des().Format(KSQLText(),&dateStr); User::LeaveIfError(iMsgBackupDb.Execute(sqlStr->Des())); CleanupStack::PopAndDestroy(sqlStr);

Hope this saves you the time I wasted in finding the correct format.