spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Som Lima <somplastic...@gmail.com>
Subject Re: Converting a date to milliseconds with time zone in Scala
Date Tue, 28 Apr 2020 20:31:13 GMT
import java.time._
import java.util.Date
import java.text.SimpleDateFormat
import java.util.Locale
import java.util.SimpleTimeZone

object CalendarDemo extends App {

    println("Calendar Demo")
     val pattern = "EEEEE dd MMMMM yyyy HH:mm:ss.SSSZ";
    val simpleDateFormat = (new SimpleDateFormat(pattern, new Locale("en",
"UK")));
    val date = simpleDateFormat.format(new Date());
    System.out.println(date);

    val pattern2 = "dd yyyy MM HH:mm:ss.SSSSSSSSSZ";
    val simpleDateFormat2 = (new SimpleDateFormat(pattern2, new
Locale("en", "UK")));
    val date2 = simpleDateFormat2.format(new Date());
    System.out.println(date2);

/* *
    Pattern Syntax

You can use the following symbols in your formatting pattern:
G Era designator (before christ, after christ)
y Year (e.g. 12 or 2012). Use either yy or yyyy.
M Month in year. Number of M's determine length of format (e.g. MM, MMM or
MMMMM)
d Day in month. Number of d's determine length of format (e.g. d or dd)
h Hour of day, 1-12 (AM / PM) (normally hh)
H Hour of day, 0-23 (normally HH)
m Minute in hour, 0-59 (normally mm)
s Second in minute, 0-59 (normally ss)
S Millisecond in second, 0-999 (normally SSS)
E Day in week (e.g Monday, Tuesday etc.)
D Day in year (1-366)
F Day of week in month (e.g. 1st Thursday of December)
w Week in year (1-53)
W Week in month (0-5)
a AM / PM marker
k Hour in day (1-24, unlike HH's 0-23)
K Hour in day, AM / PM (0-11)
z Time Zone
' Escape for text delimiter
' Single quote
    **/

}


On Tue, 28 Apr 2020, 19:18 Edgardo Szrajber, <szrajber@yahoo.com.invalid>
wrote:

> Hi
> please check combining unix_timestamp and from_unixtime,
> Something like:
> from_unixtime(unix_timestamp( "06-04-2020 12:03:43"),"yyyy-MM-dd'T'HH:mm:ss
> Z")
>
> please note that I just wrote without any validation.
>
> In any case, you might want to check the documentation of both functions
> to check all valid formats. Also note that this functions are universal
> (not only in Spark, Hive) so you have a huge amount of documentation
> available.
>
> Bentzi
>
>
> On Tuesday, April 28, 2020, 08:32:18 PM GMT+3, Mich Talebzadeh <
> mich.talebzadeh@gmail.com> wrote:
>
>
> Unfortunately that did not work.
>
> any other suggestions?
>
> thanks
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
>
> On Tue, 28 Apr 2020 at 17:41, Mich Talebzadeh <mich.talebzadeh@gmail.com>
> wrote:
>
> Thanks Neeraj, I'll check it out. !
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
>
> On Tue, 28 Apr 2020 at 17:26, neeraj bhadani <bhadani.neeraj.08@gmail.com>
> wrote:
>
> Hi Mich,
>     You can try Spark DateTime function here and see if that helps.
>
>
> https://medium.com/expedia-group-tech/deep-dive-into-apache-spark-datetime-functions-b66de737950a
>
> Regards,
> Neeraj
>
> On Tue, Apr 28, 2020 at 5:15 PM Mich Talebzadeh <mich.talebzadeh@gmail.com>
> wrote:
>
> Hi,
>
> I have a date in format like 06/04/2020 12:03:43 and we want it to be
> displayed as follows:
>
> yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSZ format
>
> So the input date is  GMT date time just we do not receive the
> information with it
>
> The output should have timezone information
>
>
> Appreciate any ideas.
>
>
> Thanks,
>
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
>

Mime
View raw message