Skip to main content

Browse the archive

Revision f197204f0376c5bca5a4ebb7111b1282cd3f8199 authored by John Ayad on 14 December 2019, 21:08:15 UTC, committed by Dongjoon Hyun on 14 December 2019, 21:08:15 UTC 
[SPARK-30236][SQL][DOCS] Clarify date and time patterns supported in docs
 
### What changes were proposed in this pull request?

Link to appropriate Java Class with list of date/time patterns supported

### Why are the changes needed?

Avoid confusion on the end-user's side of things, as seen in questions like [this](https://stackoverflow.com/questions/54496878/date-format-conversion-is-adding-1-year-to-the-border-dates) on StackOverflow

### Does this PR introduce any user-facing change?

Yes, Docs are updated.

### How was this patch tested?

`date_format`:
![image](https://user-images.githubusercontent.com/2394761/70796647-b5c55900-1d9a-11ea-89f9-7a8661641c09.png)

`to_unix_timestamp`:
![image](https://user-images.githubusercontent.com/2394761/70796664-c07fee00-1d9a-11ea-9029-e82d899e3f59.png)

`unix_timestamp`:
![image](https://user-images.githubusercontent.com/2394761/70796688-caa1ec80-1d9a-11ea-8868-a18c437a5d49.png)

`from_unixtime`:
![image](https://user-images.githubusercontent.com/2394761/70796703-d4c3eb00-1d9a-11ea-85fe-3c672e0cda28.png)

`to_date`:
![image](https://user-images.githubusercontent.com/2394761/70796718-dd1c2600-1d9a-11ea-81f4-a0966eeb0f1d.png)

`to_timestamp`:
![image](https://user-images.githubusercontent.com/2394761/70796735-e6a58e00-1d9a-11ea-8ef7-d3e1d9b5370f.png)

Closes #26864 from johnhany97/SPARK-30236.

Authored-by: John Ayad <johnhany97@gmail.com>
Signed-off-by: Dongjoon Hyun <dhyun@apple.com>
1 parent 4c37a8a
History
File Mode Size
LICENSE-AnchorJS.txt -rw-r--r-- 1.1 KB
LICENSE-CC0.txt -rw-r--r-- 6.9 KB
LICENSE-JLargeArrays.txt -rw-r--r-- 1.3 KB
LICENSE-JTransforms.txt -rw-r--r-- 1.3 KB
LICENSE-antlr.txt -rw-r--r-- 1.5 KB
LICENSE-arpack.txt -rw-r--r-- 1.5 KB
LICENSE-automaton.txt -rw-r--r-- 1.4 KB
LICENSE-bootstrap.txt -rw-r--r-- 550 bytes
LICENSE-cloudpickle.txt -rw-r--r-- 1.6 KB
LICENSE-d3.min.js.txt -rw-r--r-- 1.4 KB
LICENSE-dagre-d3.txt -rw-r--r-- 1.0 KB
LICENSE-datatables.txt -rw-r--r-- 1.0 KB
LICENSE-dnsjava.txt -rw-r--r-- 1.3 KB
LICENSE-f2j.txt -rw-r--r-- 1.5 KB
LICENSE-graphlib-dot.txt -rw-r--r-- 1.0 KB
LICENSE-heapq.txt -rw-r--r-- 14.2 KB
LICENSE-istack-commons-runtime.txt -rw-r--r-- 1.5 KB
LICENSE-jakarta-annotation-api -rw-r--r-- 13.9 KB
LICENSE-jakarta-ws-rs-api -rw-r--r-- 13.9 KB
LICENSE-jakarta.activation-api.txt -rw-r--r-- 1.5 KB
LICENSE-jakarta.xml.bind-api.txt -rw-r--r-- 1.5 KB
LICENSE-janino.txt -rw-r--r-- 1.6 KB
LICENSE-javassist.html -rw-r--r-- 25.1 KB
LICENSE-javax-transaction-transaction-api.txt -rw-r--r-- 16.4 KB
LICENSE-javolution.txt -rw-r--r-- 1.4 KB
LICENSE-jaxb-runtime.txt -rw-r--r-- 1.5 KB
LICENSE-jline.txt -rw-r--r-- 1.5 KB
LICENSE-jodd.txt -rw-r--r-- 1.3 KB
LICENSE-join.txt -rw-r--r-- 1.5 KB
LICENSE-jquery.txt -rw-r--r-- 1.1 KB
LICENSE-json-formatter.txt -rw-r--r-- 547 bytes
LICENSE-jsp-api.txt -rw-r--r-- 38.5 KB
LICENSE-kryo.txt -rw-r--r-- 1.5 KB
LICENSE-leveldbjni.txt -rw-r--r-- 1.4 KB
LICENSE-machinist.txt -rw-r--r-- 1.0 KB
LICENSE-matchMedia-polyfill.txt -rw-r--r-- 149 bytes
LICENSE-minlog.txt -rw-r--r-- 1.5 KB
LICENSE-modernizr.txt -rw-r--r-- 1.1 KB
LICENSE-mustache.txt -rw-r--r-- 1.2 KB
LICENSE-netlib.txt -rw-r--r-- 2.2 KB
LICENSE-paranamer.txt -rw-r--r-- 1.6 KB
LICENSE-pmml-model.txt -rw-r--r-- 1.5 KB
LICENSE-protobuf.txt -rw-r--r-- 2.1 KB
LICENSE-py4j.txt -rw-r--r-- 1.4 KB
LICENSE-pyrolite.txt -rw-r--r-- 1.3 KB
LICENSE-re2j.txt -rw-r--r-- 1.6 KB
LICENSE-reflectasm.txt -rw-r--r-- 1.5 KB
LICENSE-respond.txt -rw-r--r-- 1.0 KB
LICENSE-sbt-launch-lib.txt -rw-r--r-- 1.5 KB
LICENSE-scala.txt -rw-r--r-- 1.5 KB
LICENSE-scopt.txt -rw-r--r-- 1.1 KB
LICENSE-slf4j.txt -rw-r--r-- 1.1 KB
LICENSE-sorttable.js.txt -rw-r--r-- 937 bytes
LICENSE-spire.txt -rw-r--r-- 1.0 KB
LICENSE-vis.txt -rw-r--r-- 406 bytes
LICENSE-xmlenc.txt -rw-r--r-- 1.5 KB
LICENSE-zstd-jni.txt -rw-r--r-- 1.3 KB
LICENSE-zstd.txt -rw-r--r-- 1.5 KB
back to top