How to extract the date and time from a timestamp field?

[Hayley]

Hello, I'm just wondering on how to extract the date or time from a timestamp field?

 

Thank you in advanced!! 

[PotatoMato]

Hi @Hayley , you can use the calculated field with SQL to extract the date or time from a timestamp field.

For Date:
SELECT CONVERT(varchar(10), [@field:Timestamp], 1)

For Time:
SELECT CONVERT(varchar(10), [@field:Timestamp], 108)

You may also visit this link for reference: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

-PotatoMato
 

[SinJunYoung]

On 2/19/2021 at 3:13 PM, Hayley said:

Hello, I'm just wondering on how to extract the date or time from a timestamp field?

 

Thank you in advanced!! 

Hello! There is an option of field formatting depending on where you will be applying this: https://howto.caspio.com/datapages/datapage-components/field-formatting-options/

[ParkLoey]

Hiyaa there! In cases when you want a different format of your date, you can refer to the list provided in this forum post:

 

 

[Kurumi]

Hi! Caspio now offers integration with OpenAI, so you can use extensions to leverage AI to update your data based on a prompt. Here's a sample use case to get the time only based on the provided Date/Time field.

Request:
Get the time in "[@field:Date_Submitted]" and change it to 12-hr time.
Determine if it is AM or PM.
Return only the final result in the format of:
HH:MM AM or PM

Result:

Change the 'Date_Submitted' field to your right field name.

To learn more about Extensions, you can check it here: https://howto.caspio.com/integration/extensions/