Skip to content
Advertisement

Tag: date

NULL MAX(col) value even though DB has a valid record

So I am trying to extract the maximum invoiceNo for current year and this is how I implemented it with PDO: However, $response keeps getting assigned to the else clause : . This is how my DB looks like: Hence I was expecting the $response to be 2022-2. I think there is something wrong with my SQL query and I

pl/SQL for loop

i having an issue on changing the month according to the loop in where the clause i have used between function the month of todate function have to be changed according to the loop if a becomes 1 then the month in where clause has to be changed according to 1 if a becomes 2 the month have be changed

Data in Oracle apex

If I want to take data for today from 00:00 until currently hour how can I do it ??? I have this table datetime hourly clientchannel servicename service_count 13_02_2022 9 ***** notification 2 Answer Presuming that datetime column’s datatype is DATE (should be), then because If datetime’s datatype is VARCHAR2 (bad choice), then you should first convert it to date,

Advertisement