InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:06:00 GMT20http://www.teradata.com/teradataforum/Topic11398-9-1.aspxSounds like business_date is a varchar column, containing a date in the format of 'mm/dd/yyyy'. If so, then I think this would give you what you want (a date data type for this value):sel business_date (date, format 'mm/dd/yyyy')from ...Mon, 12 May 2008 14:49:27 GMTrs131112http://www.teradata.com/teradataforum/Topic11398-9-1.aspxHi Mohan,sorry yaar. Plz ignore my pervious reply.Please store/change the date format to yyyymmdd then do the further processing.I think it will work. because teradata stores the date in yyyymmdd format.Please try and let me know too.Sat, 10 May 2008 03:21:44 GMTMonikahttp://www.teradata.com/teradataforum/Topic11398-9-1.aspxHi Mohan,I was able to run successfully the below query:SEL cast( cast(current_date as TIMESTAMP(0) format 'dd-mm-yyyy') AS DATE FORMAT 'YYYY-MM-DD');Current Date------------ 2008-05-09I don't see any problem in that.Fri, 09 May 2008 11:21:02 GMTMonikahttp://www.teradata.com/teradataforum/Topic11398-9-1.aspxHi Mohan,did you submit that query using SQL Assistant?This is using the windows locale definition of a date, you have to modify that using:Tools - Options - General: Display dates in this formatIf this isn't a problem related to SQL Assistant, then you have to re-phrase your question, because i didn't catch it...DieterFri, 09 May 2008 07:04:09 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11398-9-1.aspxHi ,Below sql giving invalid time stamp .12/31/2007 This is in varchar format 'mm/dd/yyyy'.I need to convert varchar to date PERIOD =======12/31/2007 SEL cast( cast(BUSINESS_DATE as TIMESTAMP(0) format 'dd-mm-yyyy') AS DATE FORMAT 'YYYY-MM-DD') from PERIOD /Thanks in advanceMohanFri, 09 May 2008 04:18:27 GMTmohan705