Databricks Certified Associate Developer for Apache Spark
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Which of the following code blocks correctly converts the openDate column (stored as integer UNIX timestamps representing seconds since 1970-01-01) into a string column openDateString formatted using Java's SimpleDateFormat (e.g., "Sunday, Dec 4, 2008 1:05 pm")?
Given the following sample data from storesDF:
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
storeId openDate
0 1100746394
1 1474410343
2 1116610009
3 1180035265
4 1408024997
A
storesDF.withColumn("openDatestring", from_unixtime(col("openDate“), “EEEE, MMM d, yyyy h:mm a"))_
B
storesDF.withColumn("openDateString", from_unixtime(col("openDate“), "EEEE, MMM d, yyyy h:mm a", TimestampType()))_
C
storesDF.withColumn("openDateString", date(col("openDate"), "EEEE, MMM d, yyyy h:mm a"))
D
storesDF.newColumn(col("openDateString"), from_unixtime("openDate", "EEEE, MMM d, yyyy h:mm a"))_
E
storesDF.withColumn("openDateString", date(col("openDate“), "EEEE, MMM d, yyyy h:mm a", TimestampType))