Tag Request

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…