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
Copy Link

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
Author
Owner
Copy Link

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
Author
Owner
Copy Link

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
Author
Owner
Copy Link

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
Author
Owner
Copy Link

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
Author
Owner
Copy Link

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
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
fbenoist68
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#303
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?