Announcement

Collapse
No announcement yet.

SQL Question (completed_dt and created)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    SQL Question (completed_dt and created)

    So there's someone in my contacts who's trying to figure out why her reports are defaulting to the time in Excel, instead of date. They're using 'completed_dt' and 'created' to get the dates, and in the .csv file it shows a date and time for each column. Is there a way to have it write just the date instead of both date and time?
    If you're at a Thanksgiving dinner, but you don't like the stuffing or the cranberry sauce or anything else, just pretend like you're eating it, but instead, put it all in your lap and form it into a big mushy ball. Then, later, when you're out back having cigars with the boys, let out a big fake cough and throw the ball to the ground. Then say, "Boy, these are good cigars!" ~ Jack Handey

    #2
    The answer is TO_CHAR:

    http://www.techonthenet.com/oracle/f...ns/to_char.php

    kthx
    If you're at a Thanksgiving dinner, but you don't like the stuffing or the cranberry sauce or anything else, just pretend like you're eating it, but instead, put it all in your lap and form it into a big mushy ball. Then, later, when you're out back having cigars with the boys, let out a big fake cough and throw the ball to the ground. Then say, "Boy, these are good cigars!" ~ Jack Handey

    Comment

    Working...
    X