HOw to get date and time

mfauzim · Post by **mfauzim** » Tue Oct 17, 2006 9:40 am

How do I get datetime in MS so that I can insert the value into my MSSQL fieldtype datetime. I understand MS only has getdate and gettime not getdatetime

Post by **Marcus Tettmar** » Tue Oct 17, 2006 9:56 am

Use the Year, Month, Day, Hour, Min and Sec functions to extract each part of the date and time and format according to your requirements. E.g.:

Code: Select all

Year>yyyy
Month>mm
Day>dd
Hour>hh
Min>nn
Sec>ss
Let>FormattedDateTime=%yyyy%-%mm%-%dd% %hh%:%nn%:%ss%