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
how do i achieve the above
thanks
ASKER CERTIFIED 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.
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
ASKER
sorry
i forgot like this
dd-mm-yyyy hh:mm:ss:sss
sorry
i forgot like this
dd-mm-yyyy hh:mm:ss:sss
sorry
ASKER
ignore above post pls
if you are wanting the milliseconds also would be
select (convert(varchar(30), getdate(), 105) + ' ' + convert(varchar(30), getdate(), 114))
select (convert(varchar(30), getdate(), 105) + ' ' + convert(varchar(30), getdate(), 114))