I'm not sure what's wrong but I'm sure that formatting your email a little bit will make it much easier for everyone to read it. Like separate the log message from the query and from your statements.
*---------------------* *Muhammad Gelbana* http://www.linkedin.com/in/mgelbana On Wed, Jan 18, 2017 at 5:18 PM, <[email protected]> wrote: > Hello I am using Drill latest version (1.9) in window in embedded mode. > I am trying to convert Date to Timestand. While Coverting I am using > following query:- > SELECT T5.`Name` AS `Website Name`, T5.`Description` AS > `Description`,TO_CHAR((CAST(T5.`CreateOn` AS TIMESTAMP)), 'MM-dd-yyyy > hh:mm:ss a') AS `CreateOn` FROM <plugingName>.<schemaName>.<tableName1> > AS T4 INNER JOIN <plugingName>.<schemaName>.<tableName2>AS T5 ON T5.`ID` > = T4.`WebsiteID` > NOTE:- IN MY DATABASE CREATEDON DATA IS LIKE 2017-01-05 08:09:17.020 > O/p:- If I used this query CreatedOn Column Converted Successfully, but My > WEBSITENAME Columns showing null values.. Website Name Description > CreateOnnull Hoostonicsas 01-05-2017 08:09:17 AMnull Horotonicssd > 01-05-2017 08:09:17 AMnull Hodsodtonics 01-05-2017 08:09:17 AMnull > Hodtotonics 01-05-2017 08:09:17 AMnull Hooewrtonics 01-05-2017 08:09:17 > AMnull Hohhotonics 01-05-2017 08:09:17 AM > But I remove TO_CHAR((CAST(T5.`CreateOn` AS TIMESTAMP)), 'MM-dd-yyyy > hh:mm:ss a') AS `CreateOn` Column from Select query Output showing fine. > Please Tell me what i am doing wrong? And How to Convert (2017-01-05 > 08:09:17.020) data to (01-05-2017 08:09:17 AM).??
