SQL question

[Rabbo]

How to convert  "Sunday, January 1, 2017" as 01/01/2017" in Teradata ?

[Myth1]

Google maadi 

[kick_seenu]

https://www.w3schools.com/sql/func_convert.asp

[Hitman]

SELECT To_Char(SYSDATE,'DAY, MON DD, YYYY') FROM dual;

SELECT To_Date('WEDNESDAY, MAR 29, 2017','DAY, MON DD, YYYY') FROM dual;

 

[SwamyRaRa]

Google it cast and convert know

[BostonBullodu]

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

[Rabbo]

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

[Rabbo]

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.

[KrishnaDevaRaya]

1 hour ago, Myth1 said:

Google maadi 

ee gif chusinappudalla navvu agatam ledhu. super gif