[Zope-DB] ZODBC getting dates from SQL Server

Tim Edwards Tim.Edwards at hwe.com.au
Mon Dec 22 02:07:58 EST 2003


Hi,

I am using ZODBC to access SQL Server through a ZSQL method. I am trying to
access dates from the result set but I can't work out what type it returns
it as and how I can use it (I need to get the day of the week for that date,
eg. if I have the date 01/05/2004 in my resultset I need to get that its a
Monday).

What type of object does ZODBC/ZSQL return DateTime columns from SQL Server
as?

Thanks

Tim Edwards

Trainee Analyst Programmer
Henry Walker Eltin
Phone: 02 9887 6327
Fax: 02 9887 2412
Email: tim.edwards at hwe.com.au





More information about the Zope-DB mailing list