[Oracle][Alteryx] Error when trying to create a Select with dates

I have been trying to make a select within two different timestamps, in the database. However no success.

Im new at SQL, so I'm sorry about the naive question. How can I fix this?

Futhermore, is there any way to avoid using codification by using this screen? What is this "Criteria"?

Thanks!

Datasets

Accepted answers

jrgo

Hi @Joker_Hazard

I believe the issue is that Oracle has a default date/time format of DD-MMM-YY (or 02-MAR-21). I don't have an Oracle environment to test a solution for you, but you can find some ways to CAST the string to their format or change the timestamp format for the session all together if you're trying to make that start/end dates dynamic using a Dynamic Input tool.

If those dates are static, you can try entering the dates in that format and see if that works.

Hope this helps!

-Jimmy

grazitti_sapna

Hi @Joker_Hazard,

Is the date field that you are using in your where clause a dynamic Date field?

If yes I would suggest you change it to a Static Date field and then try and use it in where clause.

All comments

jrgo

Hi @Joker_Hazard

If those dates are static, you can try entering the dates in that format and see if that works.

Hope this helps!

-Jimmy

Joker_Hazard

Hey Jrgo,

Thanks for the reply. I tried using " ... BETWEEN "02-JAN-21" AND "02-FEV-21" but no success.

Also I cant insert any tools before, because its the first step of my workflow, the input tool.

I will try my best to discover why is it not working.

tks

grazitti_sapna

Hi @Joker_Hazard,

Is the date field that you are using in your where clause a dynamic Date field?

If yes I would suggest you change it to a Static Date field and then try and use it in where clause.

Joker_Hazard

It's "DateTime". I'm sorry but how can I change to static? I really have no clue about it

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335