Manuals/calci/TIMESTRING

Revision as of 23:07, 26 February 2020 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''TIMESTRING(String)'''</div><br/> *<math>String</math> can be of any type of String. ==Description== *This function is shows time from a string....")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
TIMESTRING(String)


  • can be of any type of String.

Description

  • This function is shows time from a string.
  • We can convert a string to date and time using TIMESTRING() function.
  • The parameter should be any string only.

Examples

  1. TIMESTRING("1/2/2010 12:29p") = Sat Jan 02 2010 12:29:00 GMT+0530 (India Standard Time)
  2. TIMESTRING("9/1/2005 10:30a") = Thu Sep 01 2005 10:30:00 GMT+0530 (India Standard Time)
  3. TIMESTRING("2/27/2020 1:30a") = Thu Feb 27 2020 01:30:00 GMT+0530 (India Standard Time)

See Also


References

Date and Time