Want to get rid of Google Ads, click here.
+ Reply to Thread
Results 1 to 8 of 8

Thread: Timestampes in COIT 3.0.0

  1. 2002-04-16 #1
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    In Connect.It 3.0.0 there is a bug with timestamps to SQL databases. The datetimestamps are formatted wrong.



    This should be corrected in 3.0.1 due out soon.
    Reply With Quote Reply With Quote
  2. 2002-04-25 #2
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    3.0.1 has been released.
    Reply With Quote Reply With Quote
  3. 2002-07-18 #3
    Gérard
    Gérard is offline
    Member
    Join Date
    Dec 2001
    Location
    Germany
    Posts
    37

    Default

    Hello,

    does someone tell me how I can a String like "20.02.1998 12:05:34" in a valid Date/Time Value with connect it. I have been Trying ParseDDMMYYDate and it return "to long input", The function expect, I suppose the Date only but I don't like omit the Time... Does someone have an idea?

    Thanx, Gérard
    Reply With Quote Reply With Quote
  4. 2002-07-18 #4
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    You probably need to strip the elements apart and put them together again.

    Check out following function:

    replace() - with this you can replace the . with / etc. Maybe thats enough to do that.
    Best regards Tommy
    Blog - - ITIL certified - Accredited Integration Specialist – HP OpenView Service Management

    Want to keep this site alive? Consider making a donation. Click here.
    Reply With Quote Reply With Quote
  5. 2002-07-19 #5
    Gérard
    Gérard is offline
    Member
    Join Date
    Dec 2001
    Location
    Germany
    Posts
    37

    Default

    I have been trying that with Replace() after flick together. but I still have a String Type!! How to deal with this element to get him becoming now a Date/Time type?
    Thx
    Reply With Quote Reply With Quote
  6. 2002-07-19 #6
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    How about LocalToBasicTimeStamp()
    Best regards Tommy
    Blog - - ITIL certified - Accredited Integration Specialist – HP OpenView Service Management

    Want to keep this site alive? Consider making a donation. Click here.
    Reply With Quote Reply With Quote
  7. 2002-07-19 #7
    Gérard
    Gérard is offline
    Member
    Join Date
    Dec 2001
    Location
    Germany
    Posts
    37

    Default

    It returns a String as well.... Have not tried, on Monday will try and will tell you how it looks like...

    Thx
    Reply With Quote Reply With Quote
  8. 2002-07-23 #8
    Gérard
    Gérard is offline
    Member
    Join Date
    Dec 2001
    Location
    Germany
    Posts
    37

    Default

    Right it returns a String, but was processed as Date/time type value!!

    Thanx, Gérard
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

     

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules