Stack Overflow
Stack Overflow

Questions tagged [ora-01830]

ORA-01830: date format picture ends before converting entire input string. Cause: You tried to enter a date value, but the date entered did not match the date format. This error can occur when you try to enter a date value without using the TO_DATE function.

ORA-01830: date format picture ends before converting entire input string

Cause:

You tried to enter a date value, but the date entered did not match the date format. This error can occur when you try to enter a date value without using the TO_DATE function.

Reference:

16 questions
40
votes
7 answers

ORA-01830: date format picture ends before converting entire input string / Select sum where date query

I am trying to execute my query through Java like this: public ResultSet execSumStatment2() throws SQLException{ String query = "Select SUM(A) as NCCSeptember from NCC where Datum >= '01-09-2013 00:00:00' and Datum <= '30-09-2013 23:59:59'"; return…
user3036627
  • 403
  • 1
  • 4
  • 4
3
votes
3 answers

How would I mass update date and time?

I have to query an update for date and time. I know how to update the date alone, but I am having trouble with adding the time to the function. Right now, as it stands, it reads 4/20/2011 1:32:07 PM. I need the recv_date field to read 4/21/2011…
Justin
  • 245
  • 5
  • 8
  • 12
2
votes
1 answer

ORA-01830: date format picture ends before converting entire input string inspite of using TO_TIMESTAMP

My query(when fired by application) fails to execute with this error in spite of using the TO_TIMESTAMP function. INSERT INTO MY_TABLE_NAME ( UPDATED_DATE, CREATED_DATE, TEST_SUBJECT, THIRD_DATE ) VALUES ( TO_TIMESTAMP('2018-05-31…
Captain Jack Sparrow
  • 449
  • 3
  • 9
2
votes
4 answers

Formatting Dates and Times in Oracle

I'm working with Oracle and I'm using SQL Developer-1.5.4.59.40 but I have a problem. I don't know how use the format for date. I want to use a format: "dd/mm/aaaa hh24:mm" but Oracle doesn't accept it. Tthe error is: ORA-01830: La máscara de…
trifolius
  • 51
  • 1
  • 1
  • 6
2
votes
2 answers

How to send a Timestamp field to Oracle stored proc. from Java despite the DB config?

I'm making a request from a java webapp to an Oracle' stored procedure which happens to have a Timestamp IN parameter. The way info travels is something like: javaWebApp --} webservice client --} ws --} storedProcedure And I send the Timestamp param…
Alfabravo
  • 7,493
  • 6
  • 46
  • 82
1
vote
2 answers

error that i get in Oracle 11.2

1.0.6 my program works excellent but in Oracle 11.2 i get error ORA-01830 what can be the problem ? is there any Difference between 11.1 and 11.2 ? thanks in advance
Gali
  • 14,511
  • 28
  • 80
  • 105
1
vote
1 answer

ORA-01830 - date format picture ends... - but only in where clause - not in select

I created an easier to test post here: ORA-01847 day of month must be between 1 and last day of month - but data is OK Problem solution described there It took me hours to search for a comparable issue in the web - finally i think only you out there…
Joggl
  • 83
  • 1
  • 2
  • 6
1
vote
1 answer

Oracle 01830 error while converting string to date in oracle procedure

Following is the first few lines of my stored procedure in oracle. All I am trying to do is to pass a string into procedure, convert it into date and use it in a query. But it doesn't seem to work. Currently, the error I am being thrown at is as…
Salik
  • 508
  • 6
  • 17
  • 35
0
votes
2 answers

TO_DATE format SQL

I'm beginner. I have a problem that I can't solved. I would like to add the arguments for DATE. But I have an exception: ORA-01830: date format picture ends before converting entire input string. My code is below. AND…
mean
  • 17
  • 4
0
votes
2 answers

ORA-01830 (runs locally, but throws error on server)

I have a python script that inserts records into a database from a dataframe using df.apply() and a sql file. There is a date field that is being inserted, and it is formatted like this: df['some_date'] = pd.to_datetime(df['some_date'],…
roshpod
  • 1
  • 1
0
votes
2 answers

Java ora-01830 date format picture ends before converting entire input string Timestamp SQL

I'm having problems getting dates from my database while using Oracle through java. If I use this in Java: SELECT * from HA2_BOOKINGS WHERE ROOM like 'R1' AND BEGINNING >= (TO_TIMESTAMP('2018-06-11 15:11:43.208', 'YYYY-MM-DD HH24:MI:SSXFF')) …
Hola
  • 51
  • 1
  • 5
0
votes
0 answers

ORA-01830: date format picture ends before converting entire input string in Oracle EBS

I'm trying to fix and error in a XML script to make a concurrent in Oracle EBS, but i'm not having success. I need to convert a parameter 'type=date 'to "dd/MM/yyyy", but everything i try, nothing works. This error is persisting everytime. My…
Jess
  • 11
  • 3
0
votes
1 answer

Oracle date time

I have four fields: Start_Date = 16-Jun-10 Start_Time = 14:37 End_Date = 16-Jun-10 End_Time = 14:38 I need to calculate the difference from start to end. I tried using the to_date(Start_date || Start_Time) but keep getting this error…
David
  • 31
  • 1
  • 2
0
votes
2 answers

Oracle Query Works on my local pc but give exception of ORA: 01830 on other machine

I have a simple sql insert statement that is a part of a asp.net web application which is working fine on my Local computer, However after I deployed the functionality to the stage environment there are problems with the SQL Queries. The database…
Khizer Jalal
  • 51
  • 3
0
votes
1 answer

Oracle: Importing spreadsheet data

I have a table which I have created in Oracle. I have three date columns in the table. I am trying to import some data into the table via oracles spreadsheet import, I have around 100 records I am looking to import, an example of the data…
Jono_2007
  • 1,016
  • 3
  • 12
  • 23
1
2