[Zope] Getting the day from a Timestamp / gvibda

[Brad Clements]

On 22 May 2001, at 15:47, Oliver Sturm wrote:

> I have a query returning a timestamp column from my interbase 6 database
> using the Going Virtual database adapter. I want to extract the values of
> the day/month/year ... from the variable. I tried this

Here are two Extension methods I use.. Pick one

def FormatDate(date,format="%a, %B %d %H:%M"):
    """format the date object"""
    if not date:
        return "[unknown]"
    t = list(date.tuple())
    if len(t) < 9:
        t.append(0)
        t.append(0)
        t.append(-1)
    
    return time.strftime(format,t)

def DateTimeCast(s):
    """convert an interbase Timestamp to datetime"""
    if not s: return s
    try:
        return apply(DateTime,s.tuple())
    except AttributeError:
        return DateTime(s)


<dtml-var "_.DateTime(date_column.tuple()).day()">



Based on this, I think this DTML might work

Brad Clements,                bkc@murkworks.com   (315)268-1000
http://www.murkworks.com                          (315)268-9812 Fax
netmeeting: ils://ils.murkworks.com               AOL-IM: BKClements