# Microsoft sql server 2012 DATENAME FUNCTION Not working

**URL:** <https://community.dremio.com/t/microsoft-sql-server-2012-datename-function-not-working/4944>\
**Category:** Uncategorized\
**Created:** [January 28, 2020, 9:36am UTC](https://community.dremio.com/t/microsoft-sql-server-2012-datename-function-not-working/4944 "2020-01-28T09:36:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yeshreddy](https://avatars.discourse-cdn.com/v4/letter/y/bbce88/32.png) [@yeshreddy](https://community.dremio.com/u/yeshreddy)\
**Post date:** [January 28, 2020, 9:36am UTC](https://community.dremio.com/t/microsoft-sql-server-2012-datename-function-not-working/4944/1 "2020-01-28T09:36:17Z")

</div>

![Capture3](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/3079f275b392679b616ee7ec85dad6245ea5cce0.png) Does Dremio support all the sql server functions?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 28, 2020, 6:45pm UTC](https://community.dremio.com/t/microsoft-sql-server-2012-datename-function-not-working/4944/2 "2020-01-28T18:45:04Z")

</div>

@yeshreddy

Dremio does not support all SQL server function but would have an alternate function. If you are trying to convert “dw” to a different data type or format, we have ways of doing it via Dremio. Also in your query the column “dw” has no reference to a base table. Below are the list of Dremio date functions and type conversions we can do today

[Date Time Functions](https://docs.dremio.com/sql-reference/sql-functions/datetime-functions.html)  
[Type Conversion](https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html)