[ https://issues.apache.org/jira/browse/SPARK-16609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15671632#comment-15671632 ]
Bill Chambers commented on SPARK-16609: --------------------------------------- I am working on this. > Single function for parsing timestamps/dates > -------------------------------------------- > > Key: SPARK-16609 > URL: https://issues.apache.org/jira/browse/SPARK-16609 > Project: Spark > Issue Type: Improvement > Components: SQL > Reporter: Michael Armbrust > Assignee: Reynold Xin > > Today, if you want to parse a date or timestamp, you have to use the unix > time function and then cast to a timestamp. Its a little odd there isn't a > single function that does both. I propose we add > {code} > to_date(<input>, <pattern>)/to_timestamp(<input>, <pattern>). > {code} > For reference, in other systems there are: > MS SQL: {{convert(<input>, <pattern id>)}}. See: > https://technet.microsoft.com/en-us/library/ms174450(v=sql.110).aspx > Netezza: {{to_timestamp(<input>, <pattern>)}}. See: > https://www.ibm.com/support/knowledgecenter/SSULQD_7.0.3/com.ibm.nz.dbu.doc/r_dbuser_ntz_sql_extns_conversion_funcs.html > Teradata has special casting functionality: {{cast(<input> as timestamp > format '<pattern>')}} > MySql: {{STR_TO_DATE(<input>, <pattern>)}}. This returns a datetime when you > define both date and time parts. See: > https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org