Try to understand datetime cast example

Community Support
1

This is from q function reference. I am trying to understand .z.Z Cananyone explain it a little in English?datetimeyearmonthweekmmddhhuu`ss$.z.Z"D"$"yyyy/mm/dd"in general:(where / can be /-. or blank)[yy]yymmddddMMM[yy]yyyyyy/[mm|MMM]/dd[mm|MMM]/dd/[yy]yy / \z 0dd/[mm|MMM]/[yy]yy / \z 1MMM is jan..dec

2

> datetimeyearmonthweekmmddhhuuss$.z.Zis simply casting local datetime(.z.Z) to datetime, year etc.\> "D"$"yyyy/mm/dd"\> in general:\> (where / can be /-. or blank)A string-ed date, like "2001 01 01" or "2001.01.01" or "2001-01-01"can be cast with "D" to a date (+ all the variations as shown)Be mindful of the \z valueq)"D"$"2009 01 01"2009.01.01q).z.Z2011.09.20T15:58:18.186q).z.z2011.09.20T14:58:19.466q)"D"$"2009 01 01"2009.01.01q)"D"$"2009-01-01"2009.01.01q)\z0q)"D"$"01/13/2001"2001.01.13For datetimes use Zq)"Z"$"01/13/2001 00:00:00.000"2001.01.13T00:00:00.000On Sep 20, 3:44?pm, dbtouch <dbto...> wrote:&gt; This is from q function reference. I am trying to understand .z.Z Can&gt; anyone explain it a little in English?&gt;&gt; datetimeyearmonthweekmmddhhuuss$.z.Z> “D”$“yyyy/mm/dd”> in general:> (where / can be /-. or blank)> [yy]yymmdd> ddMMM[yy]yy> yyyy/[mm|MMM]/dd> [mm|MMM]/dd/[yy]yy ?/ \z 0> dd/[mm|MMM]/[yy]yy ?/ \z 1> MMM is jan..dec</dbto…>

3

.z.Z / nowThanks a lot, JammyOn Sep 20, 11:03?am, “Jammy@Java” <manni.pa…> wrote:> > datetimeyearmonthweekmmddhhuuss$.z.Z&gt;&gt; is simply casting local datetime(.z.Z) to datetime, year etc.&gt;&gt; &gt; "D"$"yyyy/mm/dd"&gt; &gt; in general:&gt; &gt; (where / can be /-. or blank)&gt;&gt; A string-ed date, like "2001 01 01" or "2001.01.01" or "2001-01-01"&gt; can be cast with "D" to a date (+ all the variations as shown)&gt;&gt; Be mindful of the \z value&gt;&gt; q)"D"$"2009 01 01"&gt; 2009.01.01&gt; q).z.Z&gt; 2011.09.20T15:58:18.186&gt; q).z.z&gt; 2011.09.20T14:58:19.466&gt; q)"D"$"2009 01 01"&gt; 2009.01.01&gt; q)"D"$"2009-01-01"&gt; 2009.01.01&gt; q)\z&gt; 0&gt; q)"D"$"01/13/2001"&gt; 2001.01.13&gt;&gt; For datetimes use Z&gt;&gt; q)"Z"$"01/13/2001 00:00:00.000"&gt; 2001.01.13T00:00:00.000&gt;&gt; On Sep 20, 3:44?pm, dbtouch <dbto...> wrote:&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; &gt; This is from q function reference. I am trying to understand .z.Z Can&gt; &gt; anyone explain it a little in English?&gt;&gt; &gt; datetimeyearmonthweekmmddhhuuss$.z.Z> > “D”$“yyyy/mm/dd”> > in general:> > (where / can be /-. or blank)> > [yy]yymmdd> > ddMMM[yy]yy> > yyyy/[mm|MMM]/dd> > [mm|MMM]/dd/[yy]yy ?/ \z 0> > dd/[mm|MMM]/[yy]yy ?/ \z 1> > MMM is jan..dec</dbto…></manni.pa…>