Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    25

    Exclamation Unanswered: How to Split Datetime Column

    I have column that hold datetime , i want to split the column into many columns ex:
    column --> 01/01/2007 00:00:00
    i want tp split to day month year hour minute second

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is almost always a receipe for disaster, because it violates first normal form in a sneaky way (having the exact same data appear in more than one column). It can be done, relatively easily, but it will almost certainly hurt you because of having the columns get "out of sync" with each other.

    -PatP

Posting Permissions

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