How to convert the string type data into date format in postgres?

Question

Sorry i am new to postgres.

Servlet gives me

UPDATED: string type in the form 07-Jul-2014.

I have inserted some date in My db column using

 to_date('1963-09-01', 'YYYY-MM-DD')//my column is of Date type

So how can i convert 07-Jul-2014 into 2014-06-07 so that i can save into my tables?

What data type is that column? "string type date" does not make sense. You also want to read this: stackoverflow.com/questions/24444971/… — user330315
– user330315, Commented Jul 1, 2014 at 5:37
You shouldn't be converting that string in SQL. You should be parsing the string in your servlet (e.g. using SimpleDateFormat) and then use a PreparedStatement and setDate() to send the date to the database. — user330315
– user330315, Commented Jul 1, 2014 at 6:03

Sivakumar · Accepted Answer · 2014-07-01 06:05:25Z

2

Try this:

to_date('07-Jul-2014', 'DD-Mon-YYYY'); Will return the result in Date format '2014-07-07'

Where '07-Jul-2014' is the string from your servlet.

answered Jul 1, 2014 at 5:54

Sivakumar

1,77114 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1