Link to home
Create AccountLog in
Avatar of amrish_IT
amrish_IT

asked on

how can I format getdate function?

How can I format sql getdate fuction?..eg.  format date from 2008-03-06 00:01:00 to 06-03-08 00:001:00
Avatar of chapmandew
chapmandew
Flag of United States of America image


select convert(varchar(30),'2008-03-06 00:01:00' ,109)
ASKER CERTIFIED SOLUTION
Avatar of pollock_d
pollock_d

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of amrish_IT
amrish_IT

ASKER

thanks pollock its working for me