The multi-part identifier could not be found via convert query

Question

 select convert(date, Main_Users_ActivityLog.CreateDate);

I'm having trouble working on this query. How can I convert all contributions from a column to the type I wish to use, only a line of code?

Which RDBMS is this for? SQL is just the query language - but it often does make a difference whether you're using MySQL, PostgreSQL, Oracle, SQL Server or IBM DB2 - or something else even. Please add a relevant tag to your question! — marc_s, Nov 25 '17 at 09:05

score 0 · Accepted Answer · answered Nov 25 '17 at 09:14

0

You need to add FROM clause:

select convert(date, Main_Users_ActivityLog.CreateDate)
FROM Main_Users_ActivityLog;

answered Nov 25 '17 at 09:14

Lukasz Szozda

1 Answers1