Article View: be.comp.programming
Article #14966datediff access
From: jack
Date: Wed, 13 Dec 2000 22:50
Date: Wed, 13 Dec 2000 22:50
11 lines
1221 bytes
1221 bytes
In een query laat ik een tijd berekenen in minuten dan heeft hij vb. 105 minuten aan, ik zou dit graag omzetten in mijn query in het formaat 00:00 vb 01:45 kolom A = date 1 kolom B= date2 kolom C = datdiff b-a = 105 minuten kolom D = C = 01:45 graag info
Technical Details
Message-ID:
<%2TZ5.96672$lR2.3143697@afrodite.telenet-ops.be>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!newsfeed.online.be!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: fcea4,3f276e66f8169e36,start X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2000-12-13 14:50:37 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!newsfeed.online.be!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mail From: "jack" <hvp@pandora.be> Newsgroups: be.comp.programming Subject: datediff access Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: <%2TZ5.96672$lR2.3143697@afrodite.telenet-ops.be> Date: Wed, 13 Dec 2000 22:50:35 GMT NNTP-Posting-Host: 213.224.122.183 X-Complaints-To: abuse@pandora.be X-Trace: afrodite.telenet-ops.be 976747835 213.224.122.183 (Wed, 13 Dec 2000 23:50:35 MET) NNTP-Posting-Date: Wed, 13 Dec 2000 23:50:35 MET Organization: Pandora - Met vlotte tred op Internet