Menene abubuwan aikin jiya da lokaci da aka fi amfani da su?

Question

Accepted Answer

SQL yana ba da abubuwan aikin da aka gina cikin allunan don gyara **jiya** da **lokaci** — tsara, cire sassa, lissafin bambance. Waɗannan mahimman abubuwa ne don canjin bayani da bubugan tambayoyi da suka dogara da lokaci, ko da yake suntubaɓɓi na jiya sun bambanta da jiya.

## Abubuwan aikin jiya da aka fi amfani da su

```sql
SELECT
  UPPER(name), LOWER(name),               -- case conversion
  LENGTH(name),                           -- string length
  CONCAT(first_name, ' ', last_name),      -- join strings (or || in some DBs)
  SUBSTRING(name, 1, 3),                   -- extract a substring
  TRIM(name),                              -- remove surrounding whitespace
  REPLACE(phone, '-', ''),                 -- replace text
  LEFT(name, 3), RIGHT(name, 3),           -- leftmost/rightmost chars
  POSITION('@' IN email)                   -- find a substring's position
FROM users;
```

Abubuwan aikin jiya suna canja da cire rubutu — abubuwan da suke da amfani don tsara sigar aiki, tsegida bayani, da gina dabarbari da aka lissafi.

## Abubuwan aikin lokaci/lokaci da aka fi amfani da su

```sql
SELECT
  NOW(), CURRENT_DATE, CURRENT_TIMESTAMP,   -- current date/time
  EXTRACT(YEAR FROM created_at),            -- get a part (YEAR, MONTH, DAY, HOUR...)
  DATE_TRUNC('month', created_at),          -- truncate to a unit (Postgres)
  created_at + INTERVAL '7 days',           -- date arithmetic (add time)
  AGE(NOW(), birth_date),                   -- difference between dates (Postgres)
  TO_CHAR(created_at, 'YYYY-MM-DD')         -- format a date as text (Postgres)
FROM events;
```

Abubuwan aikin lokaci suna samun jiya na yanzu, cire sassa (shekara, wata), aiki (ƙari/cire intervals), lissafin bambance, da tsara jiya — mahimman abubuwa ne don bubugan tambayoyi da suka dogara da lokaci da rahoto.

## Tsarin gida: haɗa tsakani lokacin zamani

```sql
-- count events per month (a frequent reporting need)
SELECT
  DATE_TRUNC('month', created_at) AS month,
  COUNT(*) AS event_count
FROM events
GROUP BY DATE_TRUNC('month', created_at)
ORDER BY month;
```

Haɗa tsakani sassa ta jiya da aka cire/yanke (wata, rana, shekara) shine tsari na rahoto da aka fi amfani da shi.

## Bambance-bambancen jiya (matakala mai mahimmanci)

```text
⚠️ Function names/syntax VARY significantly by database:
  String concat: CONCAT() vs || vs +
  Date functions: DATE_TRUNC/EXTRACT (Postgres) vs DATE_FORMAT (MySQL) vs DATEPART (SQL Server)
→ Check YOUR database's documentation; the concepts transfer, the exact syntax differs.
```

## Me ya sa ya maɓa

Abubuwan aikin jiya da lokaci sune mahimman kayan aikin SQL da aka buƙaci a hakika — gyarawa jiya da aiki da lokaci sune abubuwan da ba za a taɓa gaji ba a cikin bubugan tambayoyi na ainihi (tsara sigar aiki, tsegida bayani, tacewa da rahoto da suka dogara da lokaci), saboda haka fahimtar su shi ne ilmi mai mahimmanci yau da kullun. **Abubuwan aikin jiya** (canjin halitta, haɗa, cire jiya, maye gurbin, kura) suna gudanar da canjin rubutu da tsegida, waɗanda suke bayyana a bubugan tambayoyi da yawa don tsara da gyara bayani. **Abubuwan aikin lokaci** suna da mahimmanci musamman saboda **bubugan tambayoyi da suka dogara da lokaci da rahoto suna waje** — samun lokacin yanzu, cire sassa ta jiya (shekara, wata), lissafin jiya (ƙari intervals, lissafin bambance), da tsara jiya suna buƙata don tacewa da kewayen jiya, ƙididdige shekarun/tsigon, da musamman **haɗa tsakani lokacin zamani** (ƙididdige kowane wata/rana — tsari na rahoto da aka fi amfani da shi).

Fahimtar waɗannan abubuwan aikin zai ba ka ikon gudanar da canjin rubutu da jiya waɗanda aikace-aikacen ainihi suna buƙata kullum.

Matakala mai mahimmanci a gida shi ne cewa **sunan aikin da tsarin su suna bambanta sosai da jiya ta bangare** (haɗa jiya da abubuwan aikin lokaci suna bambanta sosai tsakani PostgreSQL, MySQL, SQL Server) — saboda haka fahimtar imani (waɗanda suka haɗa) yayin duba syntax na bangare na ku mahimmanci.

Tun gyarawa jiya da lokaci shine bukaƙƙe mai yawa a cikin bubugan tambayoyi, rahoto, da sarrafa bayani, da tun haɗa tsakani jiya/tacewa shine tsakiya ga bincike, fahimtar abubuwan aikin jiya da lokaci da aka fi amfani da su — da kasancewa da sake hankali ga bambance-bambancen jiya — shi ne ilmi mai mahimmanci da aka yi a ainihi ya kamata don aiki na bayani a gida.