Popular "to-date" questions

I have to perform some inserts into an Oracle DB. I have some dates in the following format '23.12.2011 13:01:001' …

oracle to-date

I want to convert the follow string to date: 2004-09-30 23:53:48,140000000 I tried: to_date('#', 'YYYY-MM-DD HH24:MI:…

oracle to-date

I have a to compare dates in 2 tables but the problem is that one table has the date in DD-Mon-YY …

sql oracle date-format to-date

I have csv file that has "17 September, 2009 11:06:06 AM" as COMPLETED_ON variable I am using sql loader to load data …

oracle sql-loader to-date

I have the following in my SQL where clause. This is running against an Oracle database. The sc_dt field …

sql oracle to-date

I am having query on the below sql. Please help me. select to_date(sysdate, 'DD MONTH YYYY') , to_date(…

sql oracle to-date

Dear SQL Gurus from Stack Overflow: Environment: Oracle I'm trying to understand why I can't do a to_date selection …

sql oracle datetime to-date

I have a functional select statement that has a where clause, in the where clause there is a statement like …

sql oracle date datetime to-date

I need to convert a string into a Date in oracle. The format of the string is like this: '08/11/1999 05:45:00 …

oracle to-date

I have data in the date column as below. reportDate 21-Jan-17 02-FEB-17 I want to write a query to fetch …

oracle date to-date

Top "To-date" questions