days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples in the array. For example: 191 Data Types SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_positions ----------------- 2 SELECT array_positions(ARRAY[1, 4, 3 to_char(-125.8, '999D99S') to_date(text, text) date convert string to date to_date('05 Dec 2000', 'DD Mon YYYY') to_number(text, text) numeric convert string to numer- ic to_num- ber('12,454.8-', '99G999D9S')

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_positions ----------------- 2 SELECT array_positions(ARRAY[1, 4, 3 to_char(-125.8, '999D99S') to_date(text, text) date convert string to date to_date('05 Dec 2000', 'DD Mon YYYY') to_number(text, text) numeric convert string to numeric to_num- ber('12,454.8-', '99G999D9S')

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) SELECT array_positions(ARRAY[1 function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) SELECT array_positions(ARRAY[1 function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) SELECT array_positions(ARRAY[1 text ) → date Converts string to date according to the given format. to_date('05 Dec 2000', 'DD Mon YYYY') → 2000-12-05 to_number ( text, text ) → numeric Converts string to numeric according to the

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) SELECT array_positions(ARRAY[1 function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); 199 Data Types array_position ---------------- 2 (1 row) function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data

assuming 30 days per month and 24 hours per day, e.g., 177 Data Types '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) SELECT array_positions(ARRAY[1 function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 36.2.5). anycompatiblerange Indicates that a function accepts any range data

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_positions ----------------- 2 SELECT array_positions(ARRAY[1, 4, 3 to_char(-125.8, '999D99S') to_date(text, text) date convert string to date to_date('05 Dec 2000', 'DD Mon YYYY') to_number(text, text) numeric convert string to numer- ic to_num- ber('12,454.8-', '99G999D9S')

days and microseconds, assuming 30 days per month and 24 hours per day, e.g., '1.75 months' becomes 1 mon 22 days 12:00:00. Only seconds will ever be shown as fractional on output. Table 8.17 shows some examples occurrences of the value in the array. For example: SELECT array_position(ARRAY['sun','mon','tue','wed','thu','fri','sat'], 'mon'); array_position ---------------- 2 (1 row) 198 Data Types SELECT function accepts any non-array data type, with automatic promotion of multiple arguments to a com- mon data type (see Section 38.2.5). anycompatiblerange Indicates that a function accepts any range data