All Questions
2,053
questions
0
votes
2
answers
49
views
Is there any method to convert a varchar with specific format into time in Oracle SQL?
I have a table with three columns, one of the columns ateststatus_date has the following format: e.g:
28-MAY-24 11.57.20.000000 PM
and it's defined as varchar(2). I used To_date() and ...
- 11
2
votes
0
answers
60
views
ColdFusion Oracle 12c Two Year date defaulting to 1900s instead of 2000s
I have a form with a number of date fields in it.
input tag - cfinput type="text" name="orientation_date" value="#dateFormat(getData.orientation_date,'mm/dd/yyyy')#" ...
- 45
-1
votes
2
answers
40
views
Merge data with overlapping dates in oracle
I have data in 2 tables and I need to split/and merge the data from table1 based on the data in table2 by looking for any overlaps in both. Can anybody provide tips to get this done in oracle?
Table1:...
- 101
1
vote
1
answer
25
views
Oracle SQL difference in days between two dates with different formats - SYSDATE and a VARCHAR2
I am trying to find the difference in days between a VARCHAR2 value (context sensitive) in format YYYY-MM-DD HH24:MI:SS and SYSDATE.
If I use in select
TO_DATE(peevf.screen_entry_value,'YYYY-MM-DD ...
- 11
0
votes
0
answers
31
views
Data flow from Oracle to SQL Server using open query
I have a table in oracle server and I am trying to move the data in a SQL table, I created a linked server which works fine, when I try to move the data by specifying the where clause, it does not ...
0
votes
2
answers
43
views
Oracle multiple order by query optimization
My Table structure & data-
CREATE TABLE BRAND_OFFERS
(
ID NUMBER(15,0)
, NAME VARCHAR2(80 CHAR)
, OPEN DATE
, CLOSE DATE
, ENROLLED DATE
);
-- expired offers
insert into ...
0
votes
1
answer
31
views
convert date in rows to columns in Oracle19
I have from date and to date as parameter. I am getting result in rows as below query.
SELECT
(to_date('29-04-2024','DD-MM-YYYY') - level + 1) AS day
FROM
dual
CONNECT BY LEVEL <= (to_date('01-...
- 281
1
vote
3
answers
93
views
Creating a dynamic date, so that i dont have to manually input the date next year
I have a SQL query as shown below. I would like to have dynamic dates for the current and previous financial years, so that when I run the code in the future, I don't have to manually update the ...
- 43
0
votes
0
answers
11
views
How to calculate minutes between 2 dates with time excluding minutes of weekend days in Oracle? [duplicate]
i saw many posts regarding this but all is related to business hours. My case is different, i just want to calculate minutes between 2 dates (and time) excluding weekend days
Example
enter image ...
- 3
1
vote
1
answer
23
views
Invalid and mismatched count
When I run below query:
select trunc(create_date), count(*) as num_created
from mytable WHERE create_date >= (sysdate -9)
group by trunc(create_date) order by 1;
The output:
06-MAR-24 7
07-MAR-...
- 3,160
0
votes
2
answers
56
views
DATE with PHP oci_pdo and ORACLE db - TO_DATE doest work
I'm trying to write a date in a Oracle database date column using php and pdo_oci ,but I got the above error and I can't go on:
SQLSTATE[HY000]: General error: 1858 OCIStmtExecute: ORA-01858: a non-...
0
votes
1
answer
39
views
OracleDb for Node.js searching date with like and wildcard seems not to work while in oracle application client it does
i'm using oracleDB for NodeJS, i dont know why query having the
LIKE '%/12'
not working on Date types and returns always empty array likewise it's still returning results for the same query inside ...
- 36
1
vote
3
answers
78
views
Find the previous Monday's date in Oracle
How do I check that a specific date is a Monday? Then if it is not a Monday, how do I write a SQL script to give me the date of the previous Monday? For example, if the date (27/2/2024) is a Tuesday, ...
- 25
0
votes
1
answer
102
views
"date not valid for month specified" error
I am running the below query but i keep getting the error "date not valid for month specified"
update PERSONNEL P
set P.ACTIVE =UPPER('N')
where
P.PERSONNEL_ID in (SELECT PERSONNEL_ID ...
- 15
0
votes
0
answers
31
views
Date Parameter in Oracle [duplicate]
I will run the stored procedure with C#.
But there is a Date parameter that the procedure requires. I couldn't find how to write this in C#.
This is PL/SQL codes:
DECLARE
e_ DATE := to_date('...
- 479