Rabbo Posted March 29, 2017 Report Share Posted March 29, 2017 How to convert "Sunday, January 1, 2017" as 01/01/2017" in Teradata ? Quote Link to comment Share on other sites More sharing options...
Myth1 Posted March 29, 2017 Report Share Posted March 29, 2017 Google maadi Quote Link to comment Share on other sites More sharing options...
kick_seenu Posted March 29, 2017 Report Share Posted March 29, 2017 https://www.w3schools.com/sql/func_convert.asp Quote Link to comment Share on other sites More sharing options...
Hitman Posted March 29, 2017 Report Share Posted March 29, 2017 SELECT To_Char(SYSDATE,'DAY, MON DD, YYYY') FROM dual; SELECT To_Date('WEDNESDAY, MAR 29, 2017','DAY, MON DD, YYYY') FROM dual; Quote Link to comment Share on other sites More sharing options...
SwamyRaRa Posted March 29, 2017 Report Share Posted March 29, 2017 Google it cast and convert know Quote Link to comment Share on other sites More sharing options...
BostonBullodu Posted March 29, 2017 Report Share Posted March 29, 2017 5 minutes ago, Rabbo said: How to convert "Sunday, January 1, 2017" as 01/01/2017" ? If it is sql server http://www.sql-server-helper.com/tips/date-formats.aspx Quote Link to comment Share on other sites More sharing options...
Rabbo Posted March 29, 2017 Author Report Share Posted March 29, 2017 2 minutes ago, BostonBullodu said: If it is sql server http://www.sql-server-helper.com/tips/date-formats.aspx edit chesa bro i need in teradata Quote Link to comment Share on other sites More sharing options...
Rabbo Posted March 29, 2017 Author Report Share Posted March 29, 2017 16 minutes ago, Hitman said: SELECT To_Char(SYSDATE,'DAY, MON DD, YYYY') FROM dual; SELECT To_Date('WEDNESDAY, MAR 29, 2017','DAY, MON DD, YYYY') FROM dual; this works Thanks. Quote Link to comment Share on other sites More sharing options...
KrishnaDevaRaya Posted March 29, 2017 Report Share Posted March 29, 2017 1 hour ago, Myth1 said: Google maadi ee gif chusinappudalla navvu agatam ledhu. super gif Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.