Link to home
Start Free TrialLog in
Avatar of SirReadAlot
SirReadAlot

asked on

how to retrieve in date time as dd-mm-yyyy hh:mm:ss:ss

Hi experts,

how do i achieve the above

thanks
ASKER CERTIFIED SOLUTION
Avatar of talspaugh27
talspaugh27

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of talspaugh27
talspaugh27

lol both comments came in at the exact same time, looks like EE needs to break it down to the second level on the timestamps
Avatar of SirReadAlot

ASKER

sorry

i forgot like this

dd-mm-yyyy hh:mm:ss:sss

sorry
ignore above post pls
if you are wanting the milliseconds also would be
select (convert(varchar(30), getdate(), 105) + ' ' + convert(varchar(30), getdate(), 114))