0008387: adodb2-db2.DBTimeStamp uses TO_DATE() which doesn't work on DB2

ID	Project	Category	View Status	Date Submitted	Last Update
0008387	mantisbt	db db2	public	2007-09-22 04:34	2007-10-04 01:37

Reporter	vboctor	Assigned To	vboctor
Priority	normal	Severity	major	Reproducibility	have not tried
Status	closed	Resolution	fixed
Product Version	1.1.0a4
Target Version	1.1.0rc1	Fixed in Version	1.1.0rc1

Summary	0008387: adodb2-db2.DBTimeStamp uses TO_DATE() which doesn't work on DB2
Description	Patch reported by Alan Seiden: `// format and return date string in database timestamp format function DBTimeStamp($ts) { if (empty($ts) && $ts !== 0) return 'null'; if (is_string($ts)) $ts = ADORecordSet::UnixTimeStamp($ts); // original: return 'TO_DATE('.adodb_date($this->fmtTimeStamp,$ts).",'YYYY-MM-DD HH24:MI:SS')"; return adodb_date($this->fmtTimeStamp,$ts); }` This patch was reported to ADODB author via email since they don't seem to use a bug tracker.
Tags	No tags attached.