Extract the Time Out of DateTime field

Article View: borland.public.interbase.sql

Article #11201

Back to borland.public.interbase.sql Previous Next

#11201

From: Piet Doms
Date: Tue, 10 Dec 2002 20:22

21 lines
1280 bytes

Hello all,

Can somebody tell me how to extract the time value from a Datetime field

For now I use :
SELECT EXTRACT(HOUR FROM MYDATETIME) || ':' ||
EXTRACT(MINUTE FROM MYDATETIME)

FROM MYTABLE

the MYDATETIME value = 25-11-2002 19:01:00
the result will be 19:1

What I'm looking for = 19:01 instead of 19:1

Anybody any ideas

Thanks
Piet

Remove the spam_ from the emailadress

Technical Details

Message-ID: <3df64a89$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,f123919f75f61b5f,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-10 12:15:21 PST
From: "Piet Doms" <pvo_bv@planet.nl>
Newsgroups: borland.public.interbase.sql
Subject: Extract the Time Out of DateTime field
Date: Tue, 10 Dec 2002 21:22:44 +0100
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 62.131.174.35
Message-ID: <3df64a89$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039551113 62.131.174.35 (10 Dec 2002 12:11:53 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail