GilaMonster (1/23/2016)

---

It won't run, because you're referencing an alias in the WHERE clause. Aliases only get assigned at a point after the WHERE has run.

You could do

SELECT change_dtim,create_dtim,ckpt_id,Format([change_dtim]-[create_dtim],'hh:nn:ss') as tempo...

Eirikur Eiriksson (1/23/2016)

---

You have 15 minutes passed midnight in your query, if...

Please see the file:

https://www.dropbox.com/s/3ok41iuqg9pqd2p/1.png?dl=0

i need only the records in expression > 15 minutes

🙁

Regards,

Cachado

But i need bigger than 15 minutes!

The statement is ok but the condition > '00:15:00' dont work.

🙁

Thks,

Cachado

Still searching...

TO_CHAR(create_dtim, '%m-%d-%y')

Returns the strange error:

ERROR [HY000] [INTERSOLV][ODBC Informix driver][Informix]Unknown error message -19828.

Regards,

Cachado

Thks for...

no 🙁

ERROR [HY000] [INTERSOLV][ODBC Informix driver][Informix]Procedure (format) not found.

Regards,

Cachado

Hi,

Don´t work 🙁 with this FORMAT(GETDATE(create_dtim),'dd-MM-yyyy') !!

ERROR [HY000] [INTERSOLV][ODBC Informix driver][Informix]Procedure (getdate) not found.

Regards,

Cachado

Thank you for help, you saved my day, better to correct the night 🙂

Hug!

Cachado

Jacob Wilkins (11/19/2015)

---

There are a couple ways to do this.

Let's say you're wanting only rows where the time portion is greater than or equal to 22:15 in the date range...

This work but i need the minutes to 🙁

(create_dtim between #1/1/2015# and #1/1/2017#) and (hour(create_dtim) >= 19)

Any ideas please,

Regards,

Cachado

🙁

Dont work

I use Visual studio 2012 and the table is from database access.

Thks for your help,

Cachado

Sorry my poor english.

I want records after the time 22:15 but with this statement appear after 22 hour! 🙁

Thks,

Cachado