DelphiFAQ Home Search:
Delphi
    .NET (2)
    Database (75)
    Delphi IDE (239)
    Network (517)
    Printing (1037)
    Strings (2086)
    VCL (4255)
    Windows with Delphi (38)

 
Exchange Links
 
About this site

Links to us


Website Monitoring

Book on

 

 

 General :: Programming :: Delphi :: Database
Database development with Delphi. Includes issues with BDE, ADO and InterBase.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.
Only the 40 most recently viewed articles are shown.
You can see the full list here.
Featured Article

Extracting the Month of a Date

Question:
My table has a field LastMod of type DATE which contains the last time the record was modified. Now I'd like to group records by the month they were modified. How can I elegantly extract the month from a DATE field?

Answer:
Use the EXTRACT() function. The syntax is:

EXTRACT(modifier FROM fieldname)

where modifier can be:

YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, WEEKDAY, YEARDAY.

Example:

select EXTRACT(MONTH from LastMod) from TableName


Generated 20:01:07 on Feb 24, 2020		Most recent comments
2020-02-24 14:00:23:
by [hidden]
in Dating Scams
on Dating scammer ZHANNA:
Union City bounces back to defeat Starfires 60

As a current print reader, You can opt in for All Access warning. All Access members receive unrestricted access to our website and e edition (O ... read more
2020-02-24 13:01:23:
by [hidden]
in Dating Scams
on Dating scammer Elena Zlygosteva:
[url= https://sandeshtechn..m]Customer service resume[/url]
It is impossible to imagine the modern world without mass media and technology as they have become the essential parts of the ev ... read more
2020-02-24 12:13:48:
by [hidden]
in about DelphiFAQ
on Other Feedback:
Hello guys! I have just been employed by Peaches and Screams UK to do their onsite SEO work and I now have access to the online store.

I can publish your sponsored guest posts with one do fol ... read more
2020-02-24 10:46:59:
by FESTUS
in Dating Scams
on Dating scammer Tatyana (photos: Raven Riley):
i was lost with no hope for my wife was cheating and had always got away with it because i did not know how or always too scared to pin anything on her. with the help a friend IN PERSON OF PAIGE who ... read more
2020-02-24 09:02:49:
by [hidden]
in Dating Scams
on Dating scammer GRUPO DE DISCUSSÃO EM PORTUGUÊS:
tik tok followers generator no survey <a href=' https://howtogettikt..m/'>tik tok likes generator</a>
2020-02-24 09:02:20:
by [hidden]
in Dating Scams
on Gold digger Valeria Novitskaya from Ukraine:
tiktok for free install <a href=' https://howtogettikt..m/'>tik tok likes generator</a>
2020-02-24 06:52:56:
by anonymous
in Finances
on Well-respected bank offering Payday loans:

CONTACT US FOR ALL KINDS OF HACKING JOB @ glenfthomas@gmail.com TEXT ON (770) 824-6784 We offer professional hacking services.
2020-02-24 02:40:03:
by Tuna kush
in Other Scams
on The UK NATIONAL LOTTERY scam:
This blog is the best. You created a blog that every reader’s always appreciated your work.
[url= https://herbapproach..h-strain/] Tuna kush [/url]

2020-02-24 00:22:03:
by [hidden]
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:
Интересный пост
_________________
[url= https://smartbets.si..рская контора olimp продать ставку[/url], как зарегистриро ... read more
2020-02-23 22:44:24:
by sreg85746@gmail.com
in Dating Scams
on Primer for first time visitors (Dating Scams):
Hello
I live in chilliwack British columbia and have been chatting with a girl who claims to live in portland oregon and goes to a nursing school there so she says.and she is so she says planning ... read more