[SalesForce] Query Activity in ExactTarget – getting date out of datetime

Using ExactTarget queries to retrieve data, i found that the regular 'Date' function that should extract only the date, without time from a column, is not working.
Is there any workaround or something i can do to get only the date?

the SQL code example:

SELECT O.EVENTDATE FROM _OPEN

this query will bring the result of 2014-01-01 08:00 AM
what i want to see is '2014-01-01'
what i did in regular MYSQL client is just addid date() before the O.EVENTDATE and it worked, but it is not working in ET internal query call.

Thanks!

Best Answer

SQL Server 2008 (ET uses SQL Server) has a date type with no time, to which you could convert. Use something like

SELECT CONVERT(date, getdate()) AS testDate

for your query

----UPDATE----

Based on the additional query added, I would do 

SELECT CONVERT(date, O.EVENTDATE) AS someDate FROM _Open O
Related Topic