OraFAQ Forum: SQL & PL/SQL » select START_TIME = TO

Home » SQL & PL/SQL » SQL & PL/SQL » select START_TIME = TO_DATE returns 0 (RDBMS 12.2..0.1 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select START_TIME = TO_DATE returns 0 [message #676306]

Wed, 29 May 2019 13:57

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Hello
I have this sql statment
SELECT JOB_ID as jobId,JOB_NAME as jobName,JOB_DESC as jobDesc,ALLOW_OPS_LAUNCH as allowOpsLaunch,JOB_ARGS as jobArgs,SUBMIT_TIME as submitTime,START_TIME as startTime,END_TIME as endTime,JOB_STATUS as jobStatus,TOTAL_RECORDS as totalRecords,CURRENT_RECORD as currentRecord,FAILED_RECORDS as failedRecords,SKIPPED_RECORDS as skippedRecords,SUCCESSFUL_RECORDS as successfulRecords,MESSAGE as message,ERROR_CODE as errorCode,REPORT_NAME as reportName,PRODUCT_CODE as productCode,USERID as userid FROM TABLE o WHERE o.PRODUCT_CODE IN ('AAI', 'FF', 'LL', 'AA', 'NN') AND o.START_TIME = TO_DATE('2019-05-14', 'YYYY-MM-DD') ORDER BY o.SUBMIT_TIME desc, o.JOB_ID desc

START_TIME = TO_DATE = does not return any data,

I figure it out thanks

[Updated on: Wed, 29 May 2019 14:32]

Report message to a moderator

[Message index]

		select START_TIME = TO_DATE returns 0 By: evoradba on Wed, 29 May 2019 13:57
		Re: select START_TIME = TO_DATE returns 0 By: Michel Cadot on Wed, 29 May 2019 14:47
		Re: select START_TIME = TO_DATE returns 0 By: EdStevens on Thu, 30 May 2019 06:54
		Re: select START_TIME = TO_DATE returns 0 By: cookiemonster on Thu, 30 May 2019 07:12
		Re: select START_TIME = TO_DATE returns 0 By: Michel Cadot on Thu, 30 May 2019 07:22
		Re: select START_TIME = TO_DATE returns 0 By: Bill B on Mon, 03 June 2019 11:01

Previous Topic:	How to write SQL Query to get desire output
Next Topic:	Approximate 50MB files per day to be saved in Oracle Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:37:28 CDT 2024