How to format getDate() when using it for default value
Posted on 2004-08-10
I wanted to ask.. I have a column in my db where I use getDate()
In Enterprise Manager I just went to the area where it says default value and put in "getDate()". Not sure if this is the way to achieve what I want....
Each time a record is inserted into this table it automatically populates a column called "DateCreated" with the value returned from getDate()
However, the format comes like this:
How can I use it the same way but have my date/time formatted like:
08-10-2004 2:35 AM (I don't NEED the AM, but it would be nice to know if the time was AM or PM)
Can anyone help with the above?