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. > > > >