Role21 Posted April 20, 2019 Report Share Posted April 20, 2019 Hi, I am using TimeStamp to get the current time and date. Is there a way to get the current time only? Thanks Quote Link to comment Share on other sites More sharing options...
1 HeezyMeezy Posted May 6, 2019 Report Share Posted May 6, 2019 Hi @Role21 You can also try Select Timestamp(now.getTime()) Quote Link to comment Share on other sites More sharing options...
0 JolliBeng Posted April 20, 2019 Report Share Posted April 20, 2019 Hi @Role21, Yes, that is possible. You may use the following formula to get the current time: select convert(nvarchar,CAST(getdate() as time),100) -JolliBeng Quote Link to comment Share on other sites More sharing options...
Question
Role21
Hi, I am using TimeStamp to get the current time and date. Is there a way to get the current time only?
Thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.