×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
Vidi
Engager
Member since: ‎07-02-2020
‎07-21-2020
Community Statistics
Posts 3
Solutions 0
Karma Given 1
Karma Received 0
Member Since ‎07-02-2020
Activity Feed
Topics I've Started
View All

Re: Convert BST to America/NY (Timezone)

by in Getting Data In
‎07-21-2020 02:33 AM
‎07-21-2020 02:33 AM
I tried this it didn't work. First of all it complained about the format of strftime so I changed it to | eval BST=strftime(TransactTime/1000000000, "%d/%m/%y %H:%M:%S %Z" ) | eval NY=strptime(BST."-0500","%d/%m/%y %H:%M:%S %Z") | convert ctime(BST) | table host, BST, NY, TransactTime ... View more

Convert BST to America/NY (Timezone)

by in Getting Data In
‎07-03-2020 02:31 AM
‎07-03-2020 02:31 AM
I tried this but seems this is not working. I want to convert BST to America /NY time please. | eval BST=strftime(TransactTime/1000000000, "%d/%m/%y %H:%M:%S %Z" ) | eval TimeZone=BST+" -EST" | eval ET=strftime(strptime(TimeZone,"%d/%m/%y %H:%M:%S %Z"),"%d/%m/%y %H:%M:%S %Z") | table BST, ET ... View more
Labels

Re: How to convert date and time in UTC to EST?

by in Getting Data In
‎07-02-2020 07:23 AM
‎07-02-2020 07:23 AM
I tried this but seems this is not working. I want to convert BST to EST please. | eval BST=strftime(TransactTime/1000000000, "%d/%m/%y %H:%M:%S %Z" ) | eval TimeZone=BST+" -EST" | eval ET=strftime(strptime(TimeZone,"%d/%m/%y %H:%M:%S %Z"),"%d/%m/%y %H:%M:%S %Z") | table BST, ET ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-21-2020 05:54 AM
Karma given to
View All