I may have missed this when I looked through the list of available Tags, but in my customtext2.txt file I need a Date/Time stamp. I want to read my customtxt2.txt file data into an sql server database.
There’s *
%time% …current time
%timesec% …current time with seconds added
%date% …current date
%time-second%…Current second
%time-minute%…Current minute
%time-hour%…Current hour
%date-day%…Current day
%date-month%…Current month
%date-year%…Current year
%date-week%…Current week number (1 to 52)
%monthname%…Current month name
%dayname%…Current day name
at least. I normally use the separate tags so I can format the time date however I want.
- In taglist.txt
FWIW this is the standard format I use:
%date-year%-%date-month%-%date-day% %time-hour%:%time-minute%
Good for .php etc, don’t know if it will work for you.
Thanks for your reply, but for sql server I need an actual date/time stamp that I can import. I do use the %Date% and %Time% tags but I still need a date/time stamp
What format? AFAIK sql server can accept many different formats :?
The format would be:
yyyy-mm-dd hh:mm:ss
So add
:%time-second%
to the format I posted above.
%date-year%-%date-month%-%date-day% %time-hour%:%time-minute%:%time-second%
Thanks, that did the trip. My only issue is that appears that a date time tends to duplicate it’s self on the minute.
I don’t see that, but I don’t use seconds…