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...
0 ParkLoey Posted April 10 Report Share Posted April 10 Hi! Since caspio's timestamp function gets the whole thing (date and time), formulas or calculations are needed for the workaround as provided above. here's their function reference that is a great help for making such formulas: https://howto.caspio.com/function-reference/ 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
3 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.