Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
CAST to a CHARACTER not a TIMESTAMP if you want a character string without a millisecond (as described by your pattern) rather than a TIMESTAMP which always goes to the millisecond. _________________ Honesty is the best policy.
Insanity is the best defence.
CAST to a CHARACTER not a TIMESTAMP if you want a character string without a millisecond (as described by your pattern) rather than a TIMESTAMP which always goes to the millisecond.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum