- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Cast string to date in specific format in SAP HANA
I think you just need to use ‘TO_VARCHAR’ and ‘TO_DATE’ functions.
SELECT TO_VARCHAR(TO_DATE(<your field>, 'YYYYMMDD'), 'YYYY-MM-DD') FROM <Table>
Updated on 14-Feb-2020 10:06:12
- Related Questions & Answers
- Store data in format of XML string in SAP HANA system
- Adding millisecond to date in SAP HANA
- Set a specific Date Format in MySQL?
- How to format date string in PowerShell?
- SAP HANA Release/version with date
- Using Package specific default schema in SAP HANA
- Image format supported in SAP HANA Modeling view export
- MySQL CAST as DATE?
- How to format a date to String in Java?
- How to print date and time in specific format using JSP?
- Fetch the modified date of table in SAP HANA
- UNIX_TIMESTAMP with date in MySQL query to fetch records after a specific date in different format?
- Generating range of numbers 1…n in SAP HANA
- Using an Analytic Privilege for specific time in SAP HANA
- How to Format a Date String using SimpleDateFormat in Java?
Advertisements