June 30, 2016

SQL substring

select substr(file_date, 1, 10) from files_tb

Input: 2014-03-16-12-00-00
Output: 2014-03-16
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)