topic Re: System current Date time in Julian in Talend Studio

System current Date time in Julian

sbxr — Sat, 16 Nov 2024 04:12:32 GMT

Hi,

For A field in Tmap i want to generate Julian value of current Datetime . how can i do that,

Please help.

Re: System current Date time in Julian

TRF — Thu, 31 Oct 2019 11:08:22 GMT

Check this post https://stackoverflow.com/questions/14535983/convert-a-regular-date-to-julian-date-and-vice-versa-in-java

Re: System current Date time in Julian

sbxr — Thu, 31 Oct 2019 11:44:09 GMT

hi @TRF

I saw the solution, but don't know how to implement that please help me , this is really urgent

Regards

Re: System current Date time in Julian

TRF — Thu, 31 Oct 2019 12:25:33 GMT

You need to transpose that to a routine

Re: System current Date time in Julian

sbxr — Thu, 31 Oct 2019 14:44:50 GMT

i have created the routine using the code mentioned in the link. but how to use it for TalendDate.getDate("yyyy-MM-dd") to convert in julian

Re: System current Date time in Julian

Anonymous — Mon, 04 Nov 2019 03:27:22 GMT

If you have created the function in a routine, then you can call the routine in a job like this:
for testing, on a tJava component:
int julianDateValue=yourRoutineName.convertToJulian(TalendDate.getDate("dd.MM.yyyy") );
System.out.println(julianDateValue);

Regard
Shong

Re: System current Date time in Julian

Anonymous — Mon, 04 Nov 2019 05:14:13 GMT

Hi,

I believe following link will help you in this scenario:

https://community.talend.com/t5/Design-and-Development/How-to-convert-calendar-date-to-julian-using-tmap/td-p/80896

Regards,

Bhagwat

Re: System current Date time in Julian

sbxr — Mon, 04 Nov 2019 09:11:17 GMT

Thanks @shong @TRF @bhagwatn

The issue got resolved now.

Re: System current Date time in Julian

sbxr — Mon, 04 Nov 2019 15:34:04 GMT

FYI @shong @TRF

With the code attached i am able to convert date to julian but please help me in the code for datetime

in below mentioned format

TalendDate.getDate("yyyy-MM-dd HH:mm:ss.SSS")

Please find the attached routine

Date_To_Julian.txt