25112
asked on
changing format of getdate to include yyy-mon-....
how can you change the normal getdate() to the a format like:
2014Aug1808301403394
specifically, how to change 08 to Aug like in the above example and how to more precision beyond millisecond?
this is for sql 2012
thanks
2014Aug1808301403394
specifically, how to change 08 to Aug like in the above example and how to more precision beyond millisecond?
this is for sql 2012
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry- I do see it now.
Select format(sysdatetime() ,'yyyy MMM dd HH mm ss FFFFF')
thanks all.
Select format(sysdatetime() ,'yyyy MMM dd HH mm ss FFFFF')
thanks all.
ASKER
Select format(sysdatetime() ,'yyyy MMM dd HH mm ss FFFFFFF')
Select format(GETDATE() ,'yyyy MMM dd HH mm ss FFFFFFF')
gives
2014 Sep 16 09 46 43 7699724
2014 Sep 16 09 46 43 767 (4 precision less than the above)
what we need is ( without the 2 extra digits with sysdatetime)
2014 Sep 16 09 46 43 767__