CODEWITHSUNDEEP
sqldatetimealteryx
dlm21
dlm21

Reputation: 1

I do not want to consider the time (00:00:00) aspect of a datetime pull in SQL

I am using the following condition to pull a certain date from a database: to_date('2015-11-30', 'yyyy-mm-dd' and it only returns data from that date looking like this : 2015-11-30 00:00:00. How do I pull everything and not just data from that specific time during the day?

Upvotes: 0

Views: 103

Answers (1)

johnjps111
johnjps111

Reputation: 1170

I know this is old; but here is an Alteryx solution: in Alteryx, even though you only pulled the date portion from SQL, if it is stored in a DateTime variable in Alteryx, then it will still give you the time portion. Try forcing it to a "Date" variable (e.g. run it through a Select tool and force the data type to Date). That will remove the time portion within Alteryx and also any output files it generates.

Upvotes: 1

Related Questions