SQL Date functions in tutorial
I am working on Mode SQL tutorial and wanted to experiment with SQL Data Functions ( Add, Date Part, etc ) and keep having errors in my queries related to DATE_EXTRACT function not being recognized as a valid function. I am able to run the sample queries with this function but against modeanalytics database. Any idea what needs to be done to resolve my tutorial issues?
Thanks for any help provided.
Hi Vladimir Agajanov and Ruchita Garde ,
Thanks for writing in. Dates in SQL can be quite tricky! I'm not exactly sure what specific challenges you're both running into, but I think what may be going on here is that the function you're looking for is EXTRACT, rather than DATE_EXTRACT.
Here is an article that explains how to use EXTRACT with dates:
Hope that helps - please do reach out to our success team via in-product chat or firstname.lastname@example.org if we can be of further assistance. Thanks!Reply