12/12/2017 10:14 AM | |
Posts: 1 Rating: (1) |
Hello, i need help regarding Unix time stamp actually use standard logic which is mention below in that final out put not getting proper it is nearer to 10 to 12 hr delayed (final Unix time Stamp) Note- Also attached difference time stamp //Initialise #SecsPerDay := 24 * 60 * 60; //Number of Seconds For Year Component #YearSecs := ("Time"."Year-Final" - 1970) * 365 * #SecsPerDay; //Number of Leap Year Days excluding year 2000. #LeapDays := ("Time"."Year-Final" - 1972) / 4; #LeapYear := (("Time"."Year-Final" - 1972) MOD 4 = 0) AND ("Time"."Year-Final" <> 2000); //Number of seocnd for leap year excluding January,February of Leap Year IF (#LeapYear AND "Time"."Month Final" < 3) THEN #LeapSecs := (#LeapDays - 1) * #SecsPerDay; ELSE #LeapSecs := #LeapDays * #SecsPerDay; END_IF; //Number of seconds for month component CASE "Time"."Month Final" OF 1: #MonthSecs := 0; ; 2: #MonthSecs := 31 * #SecsPerDay; ; 3: #MonthSecs := (28 + 31) * #SecsPerDay; ; 4: #MonthSecs := (31 + 28 + 31) * #SecsPerDay; ; 5: #MonthSecs := (31 + 28 + 31 + 30) * #SecsPerDay; ; 6: #MonthSecs := (31 + 28 + 31 + 30 + 31) * #SecsPerDay; ; 7: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30) * #SecsPerDay; ; 8: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30 + 31) * #SecsPerDay; ; 9: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30 + 31 + 31) * #SecsPerDay; ; 10: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30 + 31 + 31 + 30) * #SecsPerDay; ; 11: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30 + 31 + 31 + 30 + 31) * #SecsPerDay; ; 12: #MonthSecs := (31 + 28 + 31 + 30 + 31 + 30 + 31 + 31 + 30 + 31 + 30) * #SecsPerDay; ; END_CASE; //Number of Seconds for Day Component #DaySecs := "Time"."Date Final" * #SecsPerDay; //Number of Seconds for hour Component #HourSecs := "Time"."Hour-Final" * 60 * 60; //Number of Seconds for Min Component #MinSecs := "Time"."Min-Final" * 60; //Sum Indivdual Components #"Unix Time" := #YearSecs + #LeapSecs + #MonthSecs + #DaySecs + #HourSecs + #MinSecs + "Time"."Sec-Final";
------------------------------------------------------------------------------------------ AttachmentDifference betn time stamp.zip (117 Downloads) |
Last edited by: Jen_Moderator at: 12/12/2017 1:11:48 PMNew subject after splitting and converted docx to zip data. |
|
This contribution was helpful to1 thankful Users |
12/12/2017 7:20 PM | |
Joined: 7/7/2010 Last visit: 9/24/2024 Posts: 15224 Rating: (2417)
|
What is your time zone configuration set for? Are you 10 to 12 hours off UTC (GMT - Time in England) ? Are you using system time or localized / local time? Are all your integers double integers, DINT?
|
science guy |
|
This contribution was helpful to1 thankful Users |
Follow us on