Hello, Please include the following patch for version 1.1.3 and futhers (gmt_timestamp.patch): --- src/main/xlat.c.orig 2006-07-13 20:40:54.000000000 +0400 +++ src/main/xlat.c 2006-10-23 18:16:11.733950598 +0400 @@ -782,6 +782,15 @@ } p++; break; + case 'G': /* request GMT timestamp in SQL format*/ + TM = gmtime_r(&request->timestamp, &s_TM); + len = strftime(tmpdt, sizeof(tmpdt), "%Y-%m-%d %H:%M:%S", TM); + if (len > 0) { + strNcpy(q, tmpdt, freespace); + q += strlen(q); + } + p++; + break; case 'H': /* request hour */ TM = localtime_r(&request->timestamp, &s_TM); len = strftime(tmpdt, sizeof(tmpdt), "%H", TM); Description: This patch introduces %G macro to be used in radius config files (mostly, in sql queries). It behaves like %S but unlike puts a GMT timestamp. -- Regards, Alexander