Hi Rozen,
you can get current time by call a java API and then get rowTimestamp by sql;
val currentTimeStamp=System.currentTimeMillis()val rowTimestatm =
sqlContext.sql("select rowTimestamp from tableName")
and then you can wirte a function like this
def diffDate(currentTimeStamp,rowTimeStamp ):INT={
here is something you need to do;
}
------------------ ???????? ------------------
??????: "Tal Rozen";<[email protected]>;
????????: 2015??7??22??(??????) ????0:04
??????: "user"<[email protected]>;
????: Timestamp functions for sqlContext
Hi,
I'm running a query with sql context where one of the fields is of type
java.sql.Timestamp. I'd like to set a function similar to DATEDIFF in mysql,
between the date given in each row, and now. So If I was able to use the same
syntax as in mysql it would be:
val date_diff_df = sqlContext.sql("select DATEDIFF(curdate(), rowTimestamp)
date_diff from tableName")
What are the relevant key words to replace curdate(), and DATEDIFF?
Thanks
