Parsing Date time to epoch

Community Support
1

Hi All,I am a newbie developer in Q.And now I have some difficulties in parsing dat time into epoch (since1970/1/1)in q, I am get the local and GMT datetime by .z.z/.z.ZI have tried “i”$.z.z and “j”$.z.Z but in vaindoes anyone knows how to parse a datetime into epoch(since 2000/1/1 or1970/1/1)?ThanksAd.

2

YGludCQuei5EDQpJcyBkYXlzIGFmdGVyIGVwb2NoDQoNCg0KU2VudCB1c2luZyBCbGFja0JlcnJ5
riBmcm9tIE9yYW5nZQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQWRyaWFu
IDxhZHJpYW4udGFtMjhAZ21haWwuY29tPg0KRGF0ZTogU3VuLCAyOCBGZWIgMjAxMCAwMDoyMTo1
OCANClRvOiBLZGIrIFBlcnNvbmFsIERldmVsb3BlcnM8cGVyc29uYWwta2RicGx1c0Bnb29nbGVn
cm91cHMuY29tPg0KU3ViamVjdDogW3BlcnNvbmFsIGtkYitdIFBhcnNpbmcgRGF0ZSB0aW1lIHRv
IGVwb2NoDQoNCkhpIEFsbCwNCg0KSSBhbSBhIG5ld2JpZSBkZXZlbG9wZXIgaW4gUS4NCkFuZCBu
b3cgSSBoYXZlIHNvbWUgZGlmZmljdWx0aWVzIGluIHBhcnNpbmcgZGF0IHRpbWUgaW50byBlcG9j
aCAoc2luY2UNCjE5NzAvMS8xKQ0KDQppbiBxLCBJIGFtIGdldCB0aGUgbG9jYWwgYW5kIEdNVCBk
YXRldGltZSBieSAuei56Ly56LloNCg0KSSBoYXZlIHRyaWVkICJpIiQuei56IGFuZCAiaiIkLnou
WiBidXQgaW4gdmFpbg0KDQpkb2VzIGFueW9uZSBrbm93cyBob3cgdG8gcGFyc2UgYSBkYXRldGlt
ZSBpbnRvIGVwb2NoKHNpbmNlIDIwMDAvMS8xIG9yDQoxOTcwLzEvMSk/DQoNClRoYW5rcw0KDQoN
CkFkLg0KDQotLSANCllvdSByZWNlaXZlZCB0aGlzIG1lc3NhZ2UgYmVjYXVzZSB5b3UgYXJlIHN1
YnNjcmliZWQgdG8gdGhlIEdvb2dsZSBHcm91cHMgIktkYisgUGVyc29uYWwgRGV2ZWxvcGVycyIg
Z3JvdXAuDQpUbyBwb3N0IHRvIHRoaXMgZ3JvdXAsIHNlbmQgZW1haWwgdG8gcGVyc29uYWwta2Ri
cGx1c0Bnb29nbGVncm91cHMuY29tLg0KVG8gdW5zdWJzY3JpYmUgZnJvbSB0aGlzIGdyb3VwLCBz
ZW5kIGVtYWlsIHRvIHBlcnNvbmFsLWtkYnBsdXMrdW5zdWJzY3JpYmVAZ29vZ2xlZ3JvdXBzLmNv
bS4NCkZvciBtb3JlIG9wdGlvbnMsIHZpc2l0IHRoaXMgZ3JvdXAgYXQgaHR0cDovL2dyb3Vwcy5n
b29nbGUuY29tL2dyb3VwL3BlcnNvbmFsLWtkYnBsdXM/aGw9ZW4uDQoNCg==

3

Hi,

This could help:

q)DTtoEpoch:{int$86400*float$10957+x}
q)
q).z.z
2010.03.01T09:25:07.975
q)DTtoEpoch .z.z
1267435516
q)
q).z.Z
2010.03.01T17:25:20.342
q)DTtoEpoch .z.Z
1267464326

Regards,
Magda

4

Thanks for you help Magda