Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2022 12:15 PM
@SANJEEV BANDRU ,
SELECT
CONCAT(substring(First_Name, 0, 2) , substring(Hire_Date, 0, 2), substring(Hire_Date, 3, 2)) as password
FROM
table;If Hire_date is timestamp you may need to add date_format()
My blog: https://databrickster.medium.com/
