import java.time._
import java.util.Date
import java.text.SimpleDateFormat
import java.util.Locale
import java.util.SimpleTimeZone
import org.joda.time
import org.joda.time.DateTime
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);
val fixedStr = "2020-06-04T12:03:43";
val dt = new DateTime(fixedStr);
val jdkDate = dt.toDate();
val pattern3 = "dd yyyy MM HH:mm:ss.SSSSSSSSSZ";
val simpleDateFormat3 = (new SimpleDateFormat(pattern2, new
Locale("en", "UK")));
val date3 = simpleDateFormat3.format(jdkDate);
System.out.println(date3);
/* *
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, 22:22 Mich Talebzadeh, <mich.talebza...@gmail.com>
wrote:
> Hi,
>
> Thank you all,
>
> I am just thinking of passing that date 06/04/2020 12:03:43 and
> getting the correct format from the module. In effect
>
> This date format yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSZ as pattern
>
> in other words rather than new Date() pass "06/04/2020 12:03:43" as string
>
> REgards,
>
>
> 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 21:31, Som Lima <somplastic...@gmail.com> wrote:
>
>> 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, <szraj...@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.talebza...@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.talebza...@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...@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.talebza...@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.
>>>
>>>
>>>
>>>
