fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #241] dans synthese les dates unix nécessite un +1 au premier lancement #303

New Issue
Open
opened 2023-07-04 00:03:41 +02:00 by fbenoist68 · 5 comments
fbenoist68 commented 2023-07-04 00:03:41 +02:00
Owner

Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: Mobile Portal Area: Divers Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-04 00:03:44 +02:00
Poster
Owner

Event ID: 1160
Date: 2014-02-01T16:56:54Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1160 Date: 2014-02-01T16:56:54Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 00:03:46 +02:00
Poster
Owner

Event ID: 1159
Date: 2014-02-01T16:56:54Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 1159 Date: 2014-02-01T16:56:54Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-04 00:03:51 +02:00
Poster
Owner

Event ID: 1158
Date: 2014-02-01T16:56:45Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

Il faut ajouter 1 heure car les dates depuis 1970 commencent à 23:00 ....
 
-- conversion dates UNIX en date ORACLE
         v_date_begin :=
            TRUNC (
                 TO_DATE ('01/01/1970', 'DD/MM/RRRR')
               + NUMTODSINTERVAL (1, 'hour') <<<<<<<<<<<<<<<<<<<
               + NUMTODSINTERVAL (pstart, 'SECOND'));
Event ID: 1158 Date: 2014-02-01T16:56:45Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> Il faut ajouter 1 heure car les dates depuis 1970 commencent &agrave; 23:00 ....</div> <div> &nbsp;</div> <div> -- conversion dates UNIX en date ORACLE</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;v_date_begin :=</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUNC (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TO_DATE (&#39;01/01/1970&#39;, &#39;DD/MM/RRRR&#39;)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ NUMTODSINTERVAL (1, &#39;hour&#39;) &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ NUMTODSINTERVAL (pstart, &#39;SECOND&#39;));</div>
fbenoist68 commented 2023-07-04 00:03:53 +02:00
Poster
Owner

Event ID: 1056
Date: 2013-12-10T21:38:11Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 1056 Date: 2013-12-10T21:38:11Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 00:03:56 +02:00
Poster
Owner

Event ID: 1055
Date: 2013-12-10T21:38:10Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 1055 Date: 2013-12-10T21:38:10Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#303
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?