[Zope-DB] Python/DCOracle Newbie seeking help
ChrisSorisio at PeakTechnical.com
Mon Aug 11 14:08:11 EDT 2003
I've just started playing with Python and DCOracle2, worked through some of
the examples, pulled out data, etc. All's been well except for something
that is driving me nuts.
cdb.execute("select ps_idno, ps_dten, ps_stdt, ps_r1_us, ps_s1_us, ps_r2_us,
nm_ltnm, mcmp.bs_name, mjobo.jc_idch from mnme, mpsn, mcmp, mjobo where
ps_dten > '01-AUG-2003' and mcmp.bs_idno=mpsn.ps_cs_bs and
mjobo.jc_idno=mpsn.ps_jc_jc and mnme.nm_idno=mpsn.ps_cn_nm")
results = cdb.fetchall()
for elements in results:
exampledate = elements
testTime = time.strptime(y, "%Y-%m-%d %H:%M:%S")
time = time.strftime("%d-%b-%Y", testTime)
print exampledate returns a string of the format YYYY-MM-DD HH:MM:SS.
print `exampledate` returns OracleDate("YYYY-MM-DD HH:MM:SS").
Okay, that's fine, all understood, except:
time.strptime complains that y is of type OracleDate and not a string. How
do I convert it into a string?
Thanks, I'm sure the answer will prompt me to wear a brown bag on my head
More information about the Zope-DB