Top "To-date" questions

To_date function in Vertica format?

How can I get Vertica function to_date('','format') do output like this: DDMonYYYY - 01/ABR/2012 and not like …

database date-formatting vertica to-date

oracle to_date with format doesn't show time

I have simple calculation, I subtract interval from date with time: select TO_DATE('2016-12-05 23:04:59', 'YYYY-MM-DD HH24:…

oracle format intervals to-date

PostgreSQL TO_DATE query issue

I have the following PostgreSQL query: INSERT INTO persoane_alocate(pa_id_pj,pa_id_corespondent_persoana,pa_procentaj,pa_…

sql postgresql to-date

Date format in Informix

Is it possible to print the date in the below format in Informix DB, May 19 1993 12:00AM ? Consider the below eg., …

sql informix to-date str-to-date string-to-datetime

ERROR ORA-00932: inconsistent datatypes: expected DATE got NUMBER

I am trying to execute the following sql statement for an oracle database: UPDATE PARENT SET RENEW_DATE = TO_DATE(…

sql oracle extract to-date

Date and quarter SQL ORACLE

I am currently working on oracle sql and have some issues managing dates and quarters. The first thing I try …

sql oracle date to-date

to_date with AS400

I am writing to you because I can't use the operator to_date on an AS400 database. With Oracle database, …

sql db2 ibm-midrange to-date db2-400

What is Julian Date Format

I have came through a query in SQL which will convert number we enter to word format The Query is …

sql oracle to-date julian-date

Oracle to_date function with codeigniter

I am using Codeigniter to insert data into an Oracle table which contains a date field. Sample code looks like …

php oracle codeigniter to-date