Re: Is there an HOUR function?

Posted in 1995

Catalin Badea — 2 Jun 1995 13:54:22 GMT — source: Informix-list mailing list archive (1991-1998)

Dean Peddle (dpeddle@nlnet.nf.ca) wrote: : I would like to be able to have an HOUR function that works on DATETIME : variables inthe same way that MONTH/DAY/YEAR does. For example: : SELECT * FROM mytable WHERE HOUR(mydate) = 10 : Any suggestions on something that will provide similar capability? I'm : not looking for a programming solution - must be able to be done relatively : simply as an interactive SQL query You can use the EXTEND function: SELECT * FROM mytables WHERE EXTEND(mydate, HOUR TO HOUR) = "10" Catalin. =========================================================================== Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ====== cat@tecsys.com =========== include system "disclaimer.4gh" ======