Post reply

Date formating

  • March 17, 2009 at 3:22 pm

    #127165

    I have two fields, ArrivalDate(1/5/2009 12:00 AM) and ArrivalTime(1/1/1900 12:56:00 PM) both have time and date in the fields and is a display issue.

    Im looking for SQL that would work for both TSQL and PLSQL that could either parse the date/ time out in each

    If this is even possible. I dont care how ugly.

  • March 17, 2009 at 3:31 pm

    #961431

    xgcmcbain (3/17/2009)

    Im looking for SQL that would work for both TSQL and PLSQL that could either parse the date/ time out in each

    The best way to do the formatting (especially if you want to support different dbms) is to do this in your client application.

    I don't know if there is a way which works with ORA and SSE but I don't think so.

    Greets

    Flo

  • March 17, 2009 at 10:32 pm

    #961568

    im trying to do it client side, but its a binding situation and in this case makes more sense on the original sql statment

  • March 18, 2009 at 2:56 am

    #961650

    Which development language? win-apps or web-apps?

  • March 19, 2009 at 7:31 am

    #962675

    The exact same code to format it for both on the SQL Side? Not really, the best you could do is write your own formatting function for each and then call it the same way in both.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply