Github user HyukjinKwon commented on the issue:

    https://github.com/apache/spark/pull/20015
  
    @cloud-fan and @youngbink how about reviving 
https://github.com/apache/spark/pull/14788 with a configuration to control this?
    
    AWS Redshift seems having `TRUNC` which just converts a timestamp to a date 
whereas we have Spark's `trunc` where supports date formats. This is not quite 
equivalent. I think Spark's `trunc` is more like Redshift's `DATE_TRUNC`.
    
    PostgreSQL does not have `trunc` but has `date_trunc` where we can specify 
the format and returns a timestamp always.
    
    Presto also looks not having a duplicated functionality.
    
    I think we can simply introduce an alias for `trunc` after resolving 
https://github.com/apache/spark/pull/14788.
    
    Did I maybe miss something?


---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to