How to convert datetime to string format in sql query?

Question

How to convert datetime to string format in SQL query for example just like in PHP there is function of strtotime() how can we do that in SQL query?

Possible duplicate of Convert DateTime Value into String in Mysql — Shahnawaz Kadari
– Shahnawaz Kadari, Commented Apr 1, 2018 at 7:09
it's a practice to not apply complex operations in db level (string manipulation) in case you would like to have an agile and responsive backend. — Evhz
– Evhz, Commented Apr 2, 2018 at 12:03

SevincQurbanova · Accepted Answer · 2018-04-01 12:08:11Z

1

If this oracle sql, you can use to_char (dateValue , formatMask) function. For example, TO_CHAR(sysdate, 'yyyy/mm/dd hh24:mi:ss') Result: '2003/07/09 12:04:20 ' TO_CHAR(sysdate, 'Month DD, YYYY') Result: 'July 09, 2003'

answered Apr 1, 2018 at 12:08

SevincQurbanova

3661 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

How to convert datetime to string format in sql query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related