If “x. You can use a wildcard ( * ) character to specify all fields. 531 AM As of Splunk 6. 04-26-2016 12:07 PM. Convert timepicker token to epoch time for eval, regardless of timepicker combination. | makeresults | eval message= "Happy Splunking!!!"How can I convert a field containing a duartion (not a timestamp!) in. Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for Unix time. If you want to export a string formatted date, then you'd need to create a formatted string out of _time field, like this. However, in using this query the output reflects a time format that is in EPOC format. 3 Karma Syntax: mktime (<wc-field>) Description: Convert a human readable time string to an epoch time. Hi bruno_eduardo, I belive that the convert command will work for you in this caseI'm using convert to change a time field to epoch. First you need to extract the time to upload as a field. Since your data is already indexed with the timestring in epoch seconds the easiest way to convert it would be to use the IFX field picker. , TIMEZONE offset ZULU 0 CENTRAL -6 PACIFIC -8 (I know the wording is extremely US-centric - but that's how your data look like. times. Advertisement Coins. Convert Zulu time to epoch landzaat. Solved! Jump to solution. mstime () Syntax: mstime (<wc-field>) Description: Convert a [MM:]SS. Update: Typically, epoch time is measured from 1970-01-01T00:00:00 UTC. I tried all the options and unable to see date in human readable format. I think that I am supposed to use some combination of strptime and strftime but I can't figure it you. What's the best way to convert it to the day of week? For example if I had a field called ODATE=2015-01-27 then I'd want a field called ODAY_OF_WEEK=Tuesday. Then you can calculate the difference between your timestamps in seconds (your B-A). 82" "2016-08-25T13:13:38. Subscribe to RSS Feed; Mark Topic as New; Mark Topic as Read; Float this Topic for Current User;. COVID-19 Response SplunkBase Developers Documentation. The statement "The date&time functions which work only on _time" is incorrect. However, in this case the format is not valid: $ date -d"08 18 2016 09:18:25" "+%s" date: invalid date ‘08 18 2016 09:18:25’. Hi, I wonder whether someone may be able to help me please. I guess when not specifying the date, Splunk maps the time to the previous day, if the respective timestamp hasn't passed yet (or would be 'too far into the future'? So if you evaluate it on Monday early morning, before 8 AM, it will map 8 AM. The _time field is different in that it IS epoch, but it is always shown in a text form. I wish to work out the difference of these two times and then create an average of all the results - essentially this -> Average (Acknowledge_Date-Date_Created) Search. Hi @djoobbani,. conf to have the data indexed with the time field converted for human readability. To convert the epoch seconds value you can display an additional field with the timestamp(in the format you wish. If the indexer runs on a different timezone from the source machines, e. Hope this helps, d. Subscribe to RSS Feed; Mark Topic as New; Mark Topic as Read; Float this Topic for Current User;. 1) Create a search dashboard with timerange as input. This timestamp, which is the time when the event occurred, is saved in UNIX time. Training & Certification Blog. Thanks. It is not showing any value in the human readable time column. COVID-19 Response SplunkBase Developers Documentation. Then, you just perform a lookup and calc. GMT (Greenwich Mean Time) is sometimes confused with UTC (Coordinated Universal Time). If “x” was not an already listed field in our data, then I have now created a new field and have given that field the value of 2. Friday, April 13, 2020 11:45:30 AM GMT -07:00. How to Convert the Time in a Desired Format Using SPLUNK Suppose we have a time format field in the SPLUNK. However, to extract a time from a field in the data you use the strptime () function, e. I have a time in the format of: Dec 23, 2015 11:45:26 BRST I'm trying to convert this to epoch time and later to a simple date format COVID-19 Response SplunkBase Developers Documentation BrowseI want to get the result of large epoch time to hours minutes and seconds. A timestamp with an offset from GMT (Greenwich Mean Time) 2020-04-13T11:45:30-07:00 or 2020-04-13T11:45:30Z. Splunk will convert earliest and latest timestamps in epoch format internally. We will discuss how to change time from human readable form to epoch and from epoch time to human readable. I can't write condition _time<30d@d - that is the reason. Use timeformat option to specify exact format to convert from. The timestamps must include a day. Which in this case comes out to January 1, 2016. 08-28-2014 12:53 AM. The strptime function doesn't work with timestamps that consist of only a month and year. | eval first. I want to convert my default _time field to UNIX/Epoch time and have it in a different field. Hi I am setting a time token "WFDate_tok_display1" which has timestamp value from the user click. Downvoted. . Jan 01, 1971 is 31557600 as you noticed, so you'd think that Dec 31st 1970 would be 31557600-86400, an answer which escapes my ability to run a calculator app right now, but which is decidedly greater than 0. Use your field name here. Answer. If it is string time stamp i. 07-24-2015 01:22 PM. eval COVID-19 Response SplunkBase Developers DocumentationPS: Use eval tag to convert String time to Epoch using strptime() 3) Use tokens tokEarliest and tokLatest in your other searches in the dashboard which are epoch time. 000000 is the difference in days (13), hours (08), minutes (48), seconds (09) and microseconds. Hi and thanks in advance, I am trying to convert the following time example field: 2017-03-02T09:41:38. Once that works, then this should do the math to convert _time to milliseconds, add the uploadTime, and convert the total time. I have a string from a complex JSON event providing an ISO 8601 date/time in UTC. Considering converting from epoch is one of the most common Splunk questions of all time, considering this page has 46k views, and considering that each and every answer is entirely incorrect (and the actual question itself is misleading) this page is desperately in need of removal. 0 Karma Reply. 3 ) with automatic timestamp recognition parses the timestamp ( epoch in milliseconds), but there is no strptime equivalent for that so I cant specify custom timestamp extraction. 737" "2016-08-25T11:05:32. You can use a wildcard ( * ) character to specify all fields. BrowseCOVID-19 Response SplunkBase Developers Documentation. COVID-19 Response SplunkBase Developers Documentation. I'm trying to change the "apiStartTime" which is in the following format 'Sat Mar 5 00:00:00 2016' including the apostrophes to an epoch time so I can perform some date calculations. You can specify the time format by timeforma t argument. 2. SplunkTrust. I can't write condition _time<30d@d - that is the reason. Thank you. I suggest you change your Splunk preferences to display time in UTC so you see the true time of the event. g. You can convert ContextTimeStamp_decimal out of epoch time with: | convert ctime (ContextTimeStamp_decimal) All time stamp values are in UTC. It also assumes that you want to see this human readable time value in the current time zone of the user account that is currently logged in. Splunk convert Wed Sep 23 08:00:00 PDT 2020 to _time and epoch time in splunk . 04-07-2023 12:56 PM. floor ( (new Date). g. New Member. . Mark as New;. All other brand names, product names, or trademarks belong to their respective owners. I tri. Thanks Anyways SplunkBase Developers DocumentationUsing Splunk: Splunk Search: Convert log time (epoch) to readable Date and time; Options. | makeresults | eval message= "Happy Splunking!!!" This sounds easy but I can't seem to figure it out. Go to to suggest one or to up-vote someone else's idea. I have found a number of solutions in these forums, but I cannot seem to get. You can follow this document to set up a lookup: Use lookups in Splunk Web; per Define a CSV lookup in Splunk Web: CSV lookups are best for small sets of data. You use date and time variables to specify the format that matches string. Splunk Search: How to convert time to epoch time? Options. By adding a % before the Z, Splunk will not perform this adjustment, which unless you have your timezone set as GMT you dont want (this assumes its ACTUALLY zulu time). Using the convert function or the strftime eval function provides you with the option to "name your format". To convert time strings from one format to another you must strptime() convert to epoch form and then use strftime(). floor ( (new Date). Epoch, also known as Unix timestamps, is the number of. Using %s to parse the epoch time ( in miliseconds) gives a gibberish date. Use the strftime () function to convert an epoch time to a readable format. 2 Karma. I am having a problem with my strptime in that it is not working. Hi How to convert the time format "2016-12-07T09:33:33. I am trying to convert a timestamp, StartTime (current format: 2014-05-09T19:11:52. You could just create one event instead of three, or in the example, just return the first event:| head 1 If you're working with ISO time strings but unknown times in an unknown order, you can sort lexicographically:| sort time_1 | head 1 If the time format is known but not necessarily in ISO format. . However, I cannot use Strftime once the figure. This gives Splunk enough information to assign the correct time to the event, but also allows us to run queries. For more information about working with dates and time, see. When you use _time in a search, Splunk assumes you want to see a human-readable time value, instead of an epoch time number of seconds. I'd like to convert it to a standard month/day/year format. With older versions of GNU date, you can calculate the relative difference to the UTC epoch: date -d '1970-01-01 UTC + 1234567890 seconds' If you need portability, you're out of luck. I have following Splunk Query which is trying to format Epoch captured start and end time into human readable format but seems like splunk is pulling incorrect value here. what i have so far which let converts it in a readable format. . This results in an epoch diff of "0" and if you strftime a "0" into days, it thinks it's 31 days, but it should be 0 days. This is how the Time field looks now. Tags: epoch. Premium Powerups Explore Gaming. . 08-24-2010 11:14 PM. 07-30-2010 09:53 PM. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. Splunk’s relative_time function takes in a value of start time and duration and returns a relative time value of time in epoch. . So use strptime to convert to epoch time this first:. tostring with the duration format will output the time as [days]+[hours]:[minutes]:[seconds] ie: 2+03:12:05. strptime(), the returned time. Hi, I'm looking for the answer for the question you posted, Do you find any answer for this?I think Splunk strptime () is converting the timezone. Can somebody give me some guidance on how to correct this please? Tags (4)Splunk Cloud Platform; Splunk Data Stream Processor; Splunk Data Fabric Search; Splunk Premium Solutions; Security Premium Solutions; IT Ops Premium Solutions; Engineering Premium Solutions; Apps and Add-ons; All Apps and Add-ons; Discussions. I would like the reported values of those fields to be human readable instead. e. Check if that is correctly used in your search. . By adding a % before the Z, Splunk will not perform this adjustment, which unless you have your timezone set as GMT you dont want (this assumes its ACTUALLY zulu time). The time shown is GMT and I need to use this field when using a dashboard to accurately show data. 7 Python 2. _time is always stored in the Splunk indexes as an epoch time value. Training + Certification Discussions. Subscribe to RSS Feed; Mark Topic as New; Mark Topic as Read; Float this Topic for Current User; Bookmark Topic;. I want to use props. Splunk does not have a function for converting time zones. and i want the difference epoch time to be in human readable . how to calculate duration between two events Splunk. . Divide the time difference in epoch between 86400 and round it. The rt field is a epoch computer time format. (Read Splunk Documentation and understand the difference between strptime() i. I have events that are coming in with no timestamp except for a field "event_sec" which gives me the time in epoch format. Still a bit lost here So would I do this in transforms / props for example transforms [myeval] ingest_eval = epoch_time(strptime(processed_time, SplunkBase Developers Documentation BrowseHi . I am looking to format my current time to epoch time (as we need to calculate some math function on time) Time format for incidentEndTimeStr looks like this: 4/11/16. How to convert epoch time with milliseconds into splunk at indexing time vrmandadi. Is it possible to convert the "rt" field to a user-friendly format? I searched through some of the other questions but none really addressed this specific question. Hi, I have this XML code where I'm attempting to convert the clicked time in epoch format into a human readable time but for some reason the COVID-19 Response SplunkBase Developers Documentation BrowseCOVID-19 Response SplunkBase Developers Documentation. This number hit 1 million (1,000,000) in March of 1973, and will hit one billion (1,000,000,000) on Sun Sep 9 01:46:39 2001 UTC. So I have two date fields - Date_Created & Acknowledge_Date both in the format YYYY-MM-DD HH:MM:SS. It is date time information in epoch time in seconds. Would it help to convert the message. Introduction Quick Reference Evaluation Functions Download topic as PDF Time modifiers Use time modifiers to customize the time range of a search or change the format of the. Which in this case comes out to January 1, 2016. Browse . The strptime function doesn't work with timestamps that consist of only a month and year. 04-07-2023 12:56 PM. 0 coins. This has converted the times. Description This function takes no arguments and returns the time that the search was started. e. I have unix time format on my log and wants to convert to human readable, the method using for epoch time didn't work for me. This seemed to work well, until it stopped working (we upgraded to Splunk 8 from 7 and I think this is when it stopped working. The general workflow for creating a CSV lookup in Splunk Web is to upload a file, share the lookup table file, and then create the lookup definition from the lookup table file. Converting UNIX timestamps into dates and times. 05-13-2014 11:58 AM. I think this answer needs an update and the solution would go better this way. You can convert between epoch and human readable time using other. time-format. 02-28-2023 10:53 PM. Ex: Epoch time : 9386717. The eval duration=d1-d2 subtracts the two to get your duration, then the last statement just reformats the duration to. I have a time in the format of: 3:21:34 AM 12/8/2014 I'm trying to convert this to epoch time. hence replying link again. Deployment Architecture; Getting Data In; Installation;. If you want to see the actual epoch time value, you can use eval to create an epoch time representation instead: | eval time_epoch = strftime (_time, "%s") As @mdsnmss suggested, you could also do. Try this to convert time in MM:SS. Browse . I would like to keep just the date and ditch the. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. UNIX time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), 1 January 1970. 2020-10-05 23:06:05. In 4. datetime(2019, 12, 1, 0, 0). @splunk_enjoyer You need to state your question clearly. 040875200Z" to epoch time for calculating difference and then to readable format?How would I convert from Unix Epoch time store as an INT to something that Splunk will recognise as DATETIME? Normally, in SQL I would use DATEADD();. This count starts at the Unix Epoch on January 1st, 1970 at UTC. I'm using db connect to access our SQL SCCM database which stores timestamps as NT EPOCH. It's a Splunk SOAR (formerly Phantom) forum. . 1 Karma. As i couldn't able to work with 13 Digits and when i. conf to convert it to human readable. Stack Overflow. New Member 04-03-2019 08:45 AM. strptime() will convert strings to epoch times| eval _time=strptime(time,"%a, %d %b %Y %H:%M:%S %Z")Splunk Search: Convert Millseconds to Epoch Time; Options. There are a couple of ways to convert epoch time into a human-readable format, but first you must start with epoch time in seconds rather than milliseconds. conf to convert it to human readable. 05-13-2014 11:58 AM. COVID-19 Response SplunkBase. splunk date time difference. Usage The now () function is often used with other data and time functions. So I have two date fields - Date_Created & Acknowledge_Date both in the format YYYY-MM-DD HH:MM:SS. Builder 03-26-2020 09:26 AM. Splunk Data Stream Processor. COVID-19 Response SplunkBase Developers Documentation. 1. "h") as it will convert offset to a 4 digit TZ offset (in my case +1100) and append h, so will do a relative_time addition of 1100 hours to my time, whereas it should be +11h. I'm trying to change the "apiStartTime" which is in the following format 'Sat Mar 5 00:00:00 2016' including the apostrophes to an epoch time so I can perform some date calculations. Subscribe to RSS Feed; Mark Topic as New; Mark Topic as Read; Float this Topic for Current User;This field is generated via the Splunk logging library, as I explained in my first entry here. You can specify the time format by timeformat argument. conf to convert it to human readable. 12-02-2015 07:09 PM. For example the UNIX epoch time 1484993700 is equal to Tue Jan 21 10:15:00 2020 . Awesome. 89 mktime – Convert human readable time format epoch time format. Searching the _time field. _time is always stored in the Splunk indexes as an epoch time value. In cases where you have to forward data, you must configure a heavy forwarder to handle these changes. . Solved: I have an event field called `LastBootUpTime=20120119121719. 210" |. Solved: Hi All, I want to convert the following into Epoch time ,but it is not getting resolved. I now have an average time it takes to acknowledge an incident in epoch format. conf. COVID-19 Response SplunkBase Developers Documentation. If your date is not in UTC then you will need to convert. 0. | eval utc_time = relative_time (epoch_time,strftime (epoch_time,"%z"). Downvoted. It also assumes that you want to see this human readable time value in the current time zone of the user account. However, in using this query the output reflects a time format that is in EPOC format. In practice, Perl is often available:Subtracting DATE '1970-01-01' from the value will give the number of days (and fractional hours/minutes/seconds) difference and then you can multiply by 24*60*60: (date_value - DATE '1970-01-01')*24*60*60. Since Splunk uses 32-bit epoch time, events after 2038 cannot be indexed. Convert timepicker token to epoch time for eval, regardless of timepicker combination dojiepreji. Ask Question Asked 8 years, 5 months ago. It will emit HH:MM:SS or DD+HH:MM:SS if over a day. Converting date and time to Epoch (Unix) time, and Epoch time back to human readable date. thing is with the T in the middle and the Z at the end, all the tries I am doing with strptime are failing. Splunk Administration. It uses the timezone of the logged in user instead of the server local time. Apps and Add-ons. I want to do it for time. . Solved: I am creating some of my first dashboards, and I am having trouble working out how to change the output in the column titled Time to COVID-19 Response SplunkBase Developers Documentation BrowseTry the following where the seconds you are adding are what you have form your EPOCH date. If you want to see the actual epoch time value, you can use eval to create an epoch time representation instead: | eval time_epoch = strftime (_time, "%s") As @mdsnmss suggested, you could also do. Solved: Hi, i need to write a query that converts time format from minutes to format Xh Xmin Xs my query | eval finish_time_epoch = COVID-19 Response SplunkBase Developers Documentation BrowseThis Online Converter able to convert successfully. 0. If you want to see the epoch v. Splunk Understanding Difference with epoch time and adding min. I tried different ways. Builder 03-26-2020 09:26 AM. What could be the reason behind this? See below fo. fromtimestamp(1346114717972) Traceback (most recent call last): File "<stdin>", line 1, in <module> ValueError: timestamp out of range for platform time_tSplunkTrust. This works for me: | eval time = strftime(time, "%c")The answer lies in the difference between convert and eval, rather than between mktime () and strptime (). From the search line I can easily leverage the strftime command to get the. For more information about how the Splunk software determines a time zone and the tz database,. Searching the _time field. 2. strptime () and strftime () are functions you use to convert between string representation and unix timestamp. in the example, Splunk interprets the _time_AEST variable as seconds since epoch (1970-01-01 00:00:00 UTC), and so technically Splunk is interpreting this as a different 'real world' time -- if you attempt to print the timezone of the date, it will incorrectly report the users configured timezone. An epoch is a numeric value representing time in seconds. Is there a better java time variable to convert "0" in epoch into 0. 01-10-2017 08:11 AM. Hai, i have updated the search but not getting new filelds created. "rank=msg(1489546552. News & Education. Date and time function syntax reference for various programming languages. Ex: index=bar sourcetype=foo earliest=1350538170 latest=1350538870 | more search commands. 125000-360' I am trying to convert this to a more readable format by using. If it is not working, try dividing the number by 1000 first. Splunk convert Wed Sep 23 08:00:00 PDT 2020 to _time and epoch time in splunk. 1. Epoch & Unix Timestamp Converter. Valuable hint for all coming troubleshoots. While that might seem odd, it makes addition/subtraction very easy. Hello All, I am trying to find the difference between first time and last time in epoch time. You can try strptime time specifiers and add a timezone (%z is for timezone as HourMinute format HHMM for example -0500 is for US Eastern Standard Time and %Z for timezone acronym for example EST is for US Eastern Standard Time. BrowseDashboards & Visualizations. So I've been looking at the Splunk documentation here and. You can specify the time format by timeformat argument. Convert this time format to epoch hagjos43. Convert NT Epoch Time with props. Yes 13 Digits is not supported by Splunk only 10 Digits with EPOCH is supported by Splunk API. Subsecond time variables such as %N and %Q can be used in metrics searches of metrics indexes that are enabled for millisecond timestamp resolution. Using Splunk: Splunk Search: How to convert time to strptime? Options. Splunk, Splunk>, Turn Data Into Doing, Data-to-Everything, and D2E are trademarks or. The time returned by the now () function is represented in UNIX time, or in seconds since Epoch time. Try this query. The magnifying glass in the search app will only apply to the _time field. g. Use timeformat option to specify exact format to convert from. Thanks. I wish to work out the difference of these two times and then create an average of all the results - essentially this -> Average (Acknowledge_Date-Date_Created) Search. . I'm trying to make a table of bookings from the whole 2019, my search is working as expected except for one column. 946Asia/Singapore and i use the. I want to convert it to the local time zone, in this case CST or CDT. COVID-19 Response SplunkBase Developers Documentation. BrowseThe two strptime things convert the date/time strings into epoch times (e. Browse^^^^Saves the newly filled in Epoch time blanks back into the lookup file. Thanks. So this answer looks at the new value of the timepicker whenever it changes, and figures out how to convert that value to epoch time. I'm pretty sure SPL commands and functions don't work there 😉. If fields are already in epoch, you can just calculate the difference without converting them. From the search line I can easily leverage the strftime command to get the. 09-21-2017 04:57 PM. time. I have this on my log including epoch time, how I can convert the time next to msg to readable time. eval time=tostring(filed_with_seconds, "duration") This will convert 134 to 00:02:14. Sure. Using the following worked: | tstats latest(_time) as time WHERE index=* BY index | eval time=strftime(time, "%c") Thank you!Note that this statement in this solution is wrong. To convert the start time to a text form use strftime. – mklement0. The generalized assumption in this question is that the formats cannot be known in advance or are too many to configure manually. This timestamp, which is the time when the event occurred, is saved in UNIX time. Convert it to some time format you prefer using eval and strftime. Convert Millseconds to Epoch Time IRHM73. As i couldn't able to work with 13 Digits and when i changed form 13 Digits to 10 Digits it worked out well for me. Background. you can use an eval with strptime to convert your timestamps into epoch time for comparisons and then strftime to convert them back into readable strings. . The current time now () is already epoch so you just need to convert (at least during calculation of different) createdate field to epoch. Solution. Solution. This function takes a time represented by a string and parses the time into a UNIX timestamp format. For our use case, we are uploading the 'real world time' using time since Epoch (assigned to the _time property), and additionally upload a timestamp formatted as a date in local time field which Splunk interpets as a string. You can follow this document to set up a lookup: Use lookups in Splunk Web; per Define a CSV lookup in Splunk Web: CSV lookups are best for small sets of data. One thing I forgot is _time actually is already in epoch but just displayed human readable in Splunk UI. Hi All, I am experiencing somewhat weird results when converting time to epoch in our Splunk environment. COVID-19 Response SplunkBase Developers Documentation. Hi, I wonder whether someone could help me please. I have this date string example: Mon, 01 May 2023 00:00:00 GMT how can I convert it to epoch? thanks!On Splunk Enterprise instances, if you need to modify timestamp extraction, specify the configuration on the indexers. 0. Splunk Data Fabric Search. | eval epoch1 = _time. If you want to do it in JS use something like var epoch = Math. Solved: I want to get the result of large epoch time to hours minutes and seconds. This function takes a time represented by a string and parses the time into a UNIX timestamp format. ) Free Analyti. For example, both of these are the same: Epoch = 1511324473 iso8601 = 2017-11-22T04:21:13Z. Let's assume that your. The general workflow for creating a CSV lookup in Splunk Web is to upload a file, share the lookup table file, and then create the lookup definition from the lookup table file. This is an alternative option of strptime() function in eval functions. 04-07-2023 12:56 PM. For example 23:59:59. When used on the _time field it returns the difference in seconds. Motivator 10-20-2015 01:41 AM. %X The time in the. . GMT and UTC I'm running the below query to find out when was the last time an index checked in. . Example: |eval log_time=log_time/1000 |eval c_time=strftime(log_time,"%F %T") | table log_time, c_timeExamine the events in Splunk and note the sourcetype value listed below each event. After this you divide the result by 3600 which is an hour in seconds. timestamp() print(ts) Output: 1575158400. index=someindex source="mysource" | eval. | eval Ingestion_Time_Logged=strftime( The epoch to convert is determined by a case statement. When reporting, it will then display and normalize times to the time zone of the Splunk server. I cannot influence the generation of this field (together with the other fields severity, thread and logger). Hi , I have two date formats i have to subtract to find the time duratiuon. The converted time field is renamed ms_time. , e. This works with the query above. Delta will compute the difference between nearby results using the value of a specific numeric field. Splunk Answers. I have created the following search. Solved: I have following Splunk Query which is trying to format Epoch captured start and end time into human readable format but seems like splunk is SplunkBase Developers Documentation Browse Once in epoch you can let Splunk represent it in the relative local timezone of the viewer OR always in EPOCH easily using Eval's strptime OR the convert. 01-09-2014 07:28 AM. The strptime function doesn't work with timestamps that consist of only a month and year. One way would be to make use of the strptime ()/strftime () functions of eval, which will let you convert time from strings, e. We would like to show you a description here but the site won’t allow us. The following statement converts the date in claim_filing_date into epoch time and stores it in _time. Solved: Hi I need to Convert an #epoch time to #minutes any ideas please guys would be really grateful - Thanks There are a couple of ways to convert epoch time into a human-readable format, but first you must start with epoch time in seconds rather than milliseconds. e.