Results 1 to 3 of 3

Thread: F91320 JSSCHSTTIME Convert to Date using TSQL Script

  1. #1

    F91320 JSSCHSTTIME Convert to Date using TSQL Script

    Hi, could anyone advice on how to convert the F91320 JSSCHSTTIME to a conventional Date (dd-mm-yyyy) using the TSQL Script.
    Thanks.

    WCH


  2. #2
    New Member
    Join Date
    Jan 2010
    Posts
    2

    Re: F91320 JSSCHSTTIME Convert to Date using TSQL Script

    I Have the same doubt, i know that convertion is with a bussines fuction but if you have any way to convert this column it will amazing.

    i hope your answer, thanks.

    Saludos.

  3. #3
    New Member
    Join Date
    Jul 2014
    Location
    N/A
    Posts
    2
    maybe someone is still looking for answer
    select dateadd(mi,JSSCHSTTIME,'1970-01-01 00:00')

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.